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 have one sheet (Sheet1) with two columns name and department name . On the second sheet (Sheet2) , I have One column , Name. I need to use the vlookup function to import the department names from sheet1 to the respective names in sheet 2.
Solved by E. H. in 17 mins
How can i get an #N/A return from a vlookup to go to 0
Solved by S. U. in 19 mins
hi there , I am having difficulty with the vlookup formula and will need your help
Solved by E. D. in 19 mins
hi I need a formula that selects by criteria A or B and then does a Vlookup for based on a specific value returning value A or Value B
Solved by G. U. in 13 mins
My example is: column A has customer name "EZ Cater" column B had customer number "C-00120" column C has text "AR Pymt - EZ Cater". I need a formula that makes following function if column C contains text from column A is equal with column B (customer number). Vlookup doesn't work here I tried approximate match but doesn't work.
Solved by K. D. in 21 mins
i took the datas from one excel sheet to another by the help of Vlookup . But whenever iam adding , iam getting the messages like value error
Solved by K. F. in 12 mins
I'm using vlookup to find a value that I can see exists in another book, but Excel keeps returning an #N/A. One of the values is in General form, while the other is Number form, which I know is the root of the problem. However, the value is a number that is 11 characters long so when I attempt to change the formats to match, I end up with a scientific number, which is not helpful because the first 9 digits are the same in the lookup field. How could I fix it?
Solved by V. L. in 23 mins
Hi. I would like to create a template in Excel, where if I input a list of names of staff, it would automatically return results (in another column) who they supervisors are - probably based on a list of names somewhere else in the file. There are five teams, therefore five supervisors. I'm thinking VLOOKUP or IF but I really don't know.
Solved by I. J. in 20 mins
What does a correct formula for count look like? what does a correct formula for vlookup ;ool like?
Solved by C. F. in 21 mins
Solved by F. Q. in 17 mins