“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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