Use a VLOOKUP to Get Values for Multiple Columns

I just used ,Very use full , thanks

Thanks Sir

Can you do this with an IF function?

Hello Sir, I need help for one excel file, could you please help me on that. can I email you the file and can you get me the exact value

Thank you. Answered my question in a few seconds :D

How can I use excel to find the value of multiple data cells from a table and sum the total amount by using one formula??

When the match works - I want to show B, C and D separately - Please let me know how? Thanks.

HOW is that better than =sum(A2:D2)???

Thanks, very simplified and helpful

Whats the difference between this and index

Hello how r u sir

What if i need to see multiple value instead of doing sum or average

🦅🐤看妹妹私🈲️视频➕微信号hot5383🐤🐦个风风光光个发复古哥哥让我们来一起

Great

i am trying to schedule tests with different durations for multiple people :-0

can do a video with times? :-)

I saw your video. It's really helpful but what I need to do is to apply to the cell B10 values of different cells in row 2 depend on selecting different month from a drop-down list.
let say applying vlookup in a conditional way based on monthly criteria.
Could you please help me.

You talk very fast.

Thanks Exactly what I looking for

Dear Sir,

I am kindly requesting you to help me particularly in this section...... I have 2 Sheets in Book1.. Sheet1 has 6 Columns with data and 39 Rows With data and sheet2 has 6 Columns with data and 41 Rows with data. I want to find out differences one (Not Common) between these two Sheets Sheet1 and Sheet2.

Could you kindly Explain Formula In detailed way.. as early as possible

Sincerely Thanking you,
Basvaraj,

This is great! What if you have a spreadsheet with multiple "Jacks." Can you still get all the information and still have it added together? Thanks!

How to if i want Jan. Fab .March Data in different columns by base value ?

thank you, a brilliant presentation.  Indeed a great help.

This video was so helpful to find the sum from one sheet, if i have 2 sheet and the sum has to be calculated. how can i do it
{=IFERROR(SUM(VLOOKUP(B3,'FUEL CARD PIVOT'!A:AG,{3,4,5,6,7,8,9,10},FALSE)),"-")}
this the fomula i used for single sheet ( it for 8 days )

thanks my dear

594????? You mean 954

Thanks for sharing. How would I display the values, matched with Vlookup, in adjacent columns first before applying a function like sum or average to them? For example, given the same layout as above, how would I display the lookup values in separate, but adjacent columns for January, February and March. Would I have to create a unique lookup formula for each column or could I use a constant array as you have done in the video. Thanks, Sam

Hello, If i need to get sum of all the enteries in coloum B, into H1 and Coloum C into H2, All entries in Coloum D in H3 and so on is their any formula for it
Ie while i enter the formula in H1 and drag it down i need to get all the value of different coloums in Coloum H as explained above.

Have you made one to show how to do this for multiple sheets of data?

How do I search in multiple columns though?

I've got a list from Fedex of Countries, but the data to search is going to be written by more than one source, so I need to create a more robust search.

One system might write USA, while another might write United States, while another might write US or U.S.

So I've set up all "basic" variations in a table. I want to search through the entire table with the vlookup, but it's only doing the search on the first column. My longest set of variables is out to column L, so I have a table of data B:L. It only checks criterion data against column B.

How do I tell it to search ALL columns under the table?

As with DW721's comment, this is what I'm looking for but have many rows then your small dataset. How can I expand that small array of {2,3,4} to the whole column of rows or many, many rows?

Can this be done with multiple rows instead of columns? For instance, I have an excel file of clients and the amounts they owe. They may be listed multiple times with different amounts owed. I essentially want to combine all of their amounts into one. This looks like what I need, but with rows instead of columns.

Sir, Thanks for sharing the video. I had a query that when there is an employee whose name is Adhi holding employee ID 101 and his spouse with employee ID 101 name is Diya , how can i get different names using vlook up. I have tried it but the result I get is Adhi for both as same ID I have used and it takes first name. Actually I want to get spouse name in second row.. Please help me on it

so i have an excel sheet with many employee numbers and first and last
name of employee in one sheet on a second sheet i have only couple
selected employees. How can i filter my main database to only those few
workers on the second sheet. I have pasted an example.



sheet 1 with all users information.

Employee #
FIRST_NAME
LAST_NAME

102698
Nancy
Becton

103671
Robert
Brackins

107697
Jack
Eknath

111561
Ruth
Jackson-hill

113623
Sandra
La Farge

116303
Janet
Lemus

116730
Suryaprabha
Medina

116860
Ruby
Newton

117026
Paula
Smoot

117187
Sandra
Stewart

117243
Lisa
Yoder

117414
Patsy
Zantiny






On sheet 2

Employee #
FIRST_NAME
LAST_NAME

103671
Robert
Brackins

113623
Sandra
La Farge

116860
Ruby
Newton

117243
Lisa
Yoder






On sheet 1 I want to look up only those people on sheet 2. how can i filter this, please help

nice cheers doug, how do i complete a vlookup which allows me to pull multiple columns of data into multiple cells. rather then using multiple sheet and cell references as individuals. i basically have a master data sheets that I use to create a dashboard in another sheet, but at the moment Im am linking cells individually from one sheet to the next.

This was very good.  Is there a way to have a drop down to change the sum to average or to count...etc?