Get instant live Excel expert VLOOKUP help

“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

Need help with a VLOOKUP table. Boss asked me to sort grades in the table. Will input data in the session.
Solved by T. J. in 25 mins
Hello. I have been searching for a way to do this and don't even know the right questions to ask. I have always been able to figure things out without help, except Google, but this has me stumped. What I am trying to do is develop a plant database that will show all plants I will be installing for a client's project and what I'd like to do is have the details auto-populate based on the input of a selected plant. Things like harvest dates, fertilizer recommendations, annual or perennial, water requirements, etc. I'll attach some screen shots. I have spent 4 hours trying to figure this out. I've tried IF & VLOOKUP and I don't know what else to do. I can make a data sheet for each plant variety or a table but I can't figure it out at all. I know I don't expect anyone to do the work for me, but if you could just point me in the right direction, I'd sure appreciate it! Thanks.
Solved by X. W. in 22 mins
Help with =if(isna(vlookup(A3,Macro!A:L,12,0)),"",vlookup(A3,Macro!A:L,12,0))
Solved by B. B. in 20 mins
I have win/loss columns for player stats and I need help using rank and percentile data analysis tool......I want to be able to pull up the player name using vlookup next to the rank and percentile table but I don't know how to do that; please and thank you!
Solved by K. S. in 11 mins
Need help with vlookup function and can you help me with how to calculate percentile the data analysis tool
Solved by X. J. in 30 mins
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 if you need to take longer time I am more then willing to pay for 2/3 sessions fixing this problem I have will greatly help
Solved by O. W. in 22 mins
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
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
Hi, I need to remove the list of Ids on Sheet 3 from the column C on Sheet 1. I know I need to use VlookUp but I can't seem to work it out. Can you help out with this? Thanks!
Solved by B. F. in 11 mins