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

I want to use a vlookup formula to extract all the data on a line into a spreadsheet, but the data I'm extracting from does not have the data in column A on the same line each day?
Solved by I. J. in 29 mins
I have a drop down menu consisting of (3,4,5,7.5 Single Compressor,7.5 Dual Compressors,8.5,10,12.5,15,17.5,20 and 25. when I use a vlookup using this dropdown menu as a reference everything works perfect except for when I select 7.5 Dual Compressors, i get #N/A for all of my values why is this?
Solved by C. Y. in 11 mins
I cant understand the problem and I am trying to work with the vlookup formula and is not working.
Solved by F. J. in 18 mins
I need to reorganize a poorly merged data sheet so my vlookup will work with my formulas
Solved by G. S. in 21 mins
Need VLOOKUP HELP. Trying to match the values in column A to a table range (AB:AD) . when the account number is found in the range, I want it to return the value in AD.
Solved by M. C. in 13 mins
I'm trying to build a VLOOKUP from another sheet and it's not working.
Solved by X. S. in 23 mins
I'm having trouble with the VLOOKUP from the Master sheet to the table linked to the internet on Sheet2.
Solved by F. W. in 21 mins
My VLOOKUP does not work in Excel (though it seems to work in Google Sheets). I have an internet-linked query on worksheet 'Strokes Gained' that can't be edited. I need the VLOOKUP on the 'Master Spreadsheet' to draw from this internet-linked query table. I have sought help in the past from this site and the "fix" has been to edit the 'Strokes Gained' table -- this absolutely should not happen. Can you please help?
Solved by G. J. in 12 mins
HI..Im trying to vlookup between two excel sheets but im getting mismatch na even though data is prsent in both the columns
Solved by G. F. in 16 mins
Excel question = If data in sheet 1, column A matches data in sheet 2, column A, then I need it to pull data from sheet 2 column B and place it into sheet 1 column c. what is the vlookup column formula for this?
Solved by B. J. in 17 mins