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

Hello need help with my excel chart. The Vlookup function and match are not working
Solved by Z. J. in 28 mins
I have a spreadsheet (sheet 1) that is filtered. I have another spreadsheet (sheet 2) with unique values in a column that need to be copied over to the filtered database. When I copy the column with the data in sheet 2 (note: the excel column length between the two sheets is the same), it will only copy the data from the first cell all the way down the column when I need it to copy each unique value into the filtered column on sheet 1. VLookup does not seem to be best suited to this issue and the macros I've found online do not seem to work correctly here (i.e., they unfilter sheet 1 when copying the unique values over). I'm stumped and need a solution that I can use for this very specific issue.
Solved by O. Y. in 11 mins
Is Expert 01 there? Hi, I am trying to use vlookup within vba, and I'm getting an error...not sure why.
Solved by A. J. in 27 mins
Vlookup excel formula issue. Can get the formula to work.
Solved by C. Q. in 17 mins
I am trying to add a vlookup formula to a spreadsheet. Where it should return what it found, I can only see the formula. Help
Solved by E. E. in 16 mins
why isn't this formula working? =IF(LEFT('MORS email'!$N$2,2)="XS", VLOOKUP('MORS email'!$O$2,'Broker and Clearer IDs'!$A:$C,3,)), =IF(LEFT('MORS email'!$N$2,2)="XS", VLOOKUP('MORS email'!$O$2,'Broker and Clearer IDs'!$A:$C,3,))
Solved by O. H. in 28 mins
I have a sheet with lots of IFERROR and VLOOKUP formulas. If I want to add two VLOOKUP formulas together, how do I create an IFERROR if no value is returned?
Solved by D. S. in 26 mins
need help to find out what is wrong with this formula IF(AND(B11="20-29",D11="VO2max",E11="FEMALE"),VLOOKUP(F11,$R$78:$T$82,3,TRUE),""
Solved by F. F. in 13 mins
How to get the last value froma sheet using vlookup if the same is occuring multiple times ?
Solved by A. W. in 28 mins
Formula question on sheet "Data" and VLOOKUP against columns in Function lookup sheet.
Solved by D. D. in 15 mins