 # 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
NO EXCEL FORMULA ARE WORKING IN MY PC LIKE VLOOKUP, HLOCUP,SUMIF
Solved by F. Q. in 17 mins