Get instant live Excel expert help figuring out how and when to create a VLOOKUP formula

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I'm trying to use the vlookup formula to identify specific countries for IP addresses on one worksheet by referencing information on another worksheet. I'm not exactly sure how to use data from two separate worksheets.
Solved by K. Y. in 12 mins
I would like to learn how to use Vlookup and Hlookup formulas.
Solved by K. J. in 24 mins
I have 2 columns of data. Column A with a list of items (say computer SN) and Column B with a list of Sub items (accessories). An Item (column A) can have multiple sub items (column B) and vice versa. ColumnA ColumnB Item1 SubItem1 Item2 Subitem3 Item1 Subitem3 Item3 Subitem1 There are about 250 entries. I want to create a table with unique entries. SubItem1 SubItem2 Subitem3 Item1 YES No Yes Item2 No Yes Yes Item3 Yes Yes No Not sure how to use vlookup or Index/Match.
Solved by C. C. in 28 mins
Ive made a list with data in one spreadsheet. With this data i have created a False and True list based on an IF function. I have furthermore created a counting system that counts 1,2,3...so on every time there is a TRUE. The problem now is that i want to transfer a line of data every time a number is counted, meaning that the line that is marked as TRUE needs to be transferred to the next page. Through googling i found that VLOOKUP might be useful, but i cant figure out how to use it exactly.. Can you help?
Solved by S. F. in 25 mins
Really appreciate your help. I have unique IDs for each person, but there are multiple rows for certain people who obviously will have the same ID. How do I get the lookup values in the VLOOKUP to match the IDs with multiple occurrences. I believe I have to use an index/match function, but I'm not quite sure how to use it. I've attached an example.
Solved by D. D. in 28 mins
figure out how to use the vlookup.........
Solved by V. D. in 15 mins
I want to VLOOKUP in excel, We have no Idea how to use VLOOKUP in Excel can you help us.
Solved by B. B. in 20 mins
how to use a vlookup and then go 6 cells to the right
Solved by C. J. in 12 mins
I don't understand how to use Vlookup and match functions
Solved by X. Y. in 13 mins
Can you help me how to use a vlookup & hlookup?
Solved by A. Y. in 13 mins
2