I'm trying to input a customer number on sheet 1 to lookup the customer name on sheet 2 and place it on sheet 1.
Here is the formula I've entered: =VLOOKUP(C5,Sheet2!$A$2:$D$3100,2,FALSE)
I've copied this formula done about 25 cells on sheet 1.
Most if the cells have numbers that are being looked up and some are letters. The ones with letters lookup fine. The numbers are having problems. I've tries to change the format for the cells to be General, Text, Numbers with no change.
The problem is that only the first 2 rows in the data sheet 2 will produce a right answer The rest show N/A.