Get instant live Excel expert help with VLOOKUP functions

“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

Good afternoon I have reworded below for you In date sheet I type in a drivers rego in row S then row R and Row T vlookup looks at row S and uses drivers sheet and added the name and phone number I would like so when I type in a rego and 2 drivers have the same rego a data validation shows up so I can pick which which driver should be listed with there phone number any help with this problem would be great thanks
Solved by C. H. in 20 mins
Column J contains several survey questions. Column K contains the answers to each question. Respondents were allowed to select up to three “most important support services” for each of the three questions. These will appear on multiple rows. The data will need to be re-structured using a VLOOKUP or similar method to add a column showing whether each respondent has a parent with a degree, in a similar format to the demographic fields.
Solved by T. F. in 24 mins
VLOOKUP. Column J contains several survey questions. Column K contains the answers to each question. Respondents were allowed to select up to three “most important support services” for each of the three questions. These will appear on multiple rows. The data will need to be re-structured using a VLOOKUP or similar method to add a column showing whether each respondent has a parent with a degree, in a similar format to the demographic fields.
Solved by Z. F. in 16 mins
need to use vlookup to list 3 posts based on count() in excel which shows which posts have the most comments
Solved by X. J. in 11 mins
Hello! I have a table created that I would like to be able to look up information in. The table is of artists and the shots they are assigned, with each shot being it's own line and having it's own information. Is there a way to use INDEX or VLOOKUP to put in one person's name and get all the lines of information that is assigned to them?
Solved by A. B. in 22 mins
I am doing a vlookup, but the lookup value is references more than 1 time on my sheet, which references a different amount on the column index, I need to total sum of the multiple column indexs recalled by the multiple lookupvalue entered.
Solved by D. C. in 30 mins
cant get a index(match() or vlookup to work correctly
Solved by C. E. in 30 mins
Hello, I'm trying to lookup data within a date range. It's kind of like a VLOOKUP and kind of like a COUNTIF but I can't get either to work in this scenario. Can anyone help? I can provide an example.
Solved by Z. Q. in 13 mins
Help matching data to key (VLOOKUP i think?)
Solved by M. H. in 19 mins
If the external link cannot be updated in the VLOOKUP command, where does excel get the information to put in the spreadsheet table, and how do I stop it!
Solved by A. A. in 23 mins