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

i need t know how to do a vlookup using a drop down list as value

Solved by Z. Q. in 20 mins

I have to use VLOOKUP for my assignment in class, and she gave me no explanation on how to do it (online class) and the book doesn't explain it. I don't know how it works or what to do... All the instructions say are "To determine which clothing lines may sell well online, you decide to rank them on a scale from A to E. In cell H5, using a Vlookup function, determine the product line ranking of each product based on the Yearly Sales. Use the range name assigned to the lookup table. Copy the formula through H16"

Solved by F. Y. in 23 mins

Need to use a vlookup for a column but not sure how to do it.

Solved by T. F. in 25 mins

Hi I have an assignment which requires knowledge of data analysis using stat tools, what if and vlookup. I have no idea how to do that. I have a spreadsheet that requires me to analyse using those tools.

Solved by S. S. in 29 mins

I have an excel test on Friday and want to check on how to do a vlookup and what is the formula since I am not well versed with it.

Solved by M. F. in 24 mins

I assume vlookup is the way to do this, but I cannot quite figure it out. Making a choice in one column, then another choice in another column results in a certain display in another column. I get how to do embedded vlookup to do that, but the problem is that the final result is not a single item. It can be several different things.

Solved by D. D. in 30 mins

I am trying to use a vlookup or index match but cant figure out how to do it whilst matching two variables.

Solved by D. E. in 18 mins

I need a solution on vlookup. I am using vlookup for simple phrases lookup A1 in B1 . However when i want to search for a specific word in a sentence within a sell then use vlookup for that word in another cell. I have no idea how to do that.

Solved by S. H. in 12 mins

I need to use a vlookup in a filtered table and not sure how to do it

Solved by E. F. in 23 mins