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

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

how to use the vlookup function in excel? 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

how to use vlookup in excel 2010 step by step? figure out how to use the vlookup.........

Solved by V. D. in 15 mins

What is vlookup meaning?

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 tell me what is vlookup and hlookup?

Solved by A. Y. in 13 mins