Forum Discussion
Lookup
I trying to use vlookup for the first time. I have a workbook with 2 sheets. Sheet 1 will have the vlookup for sheet 2. I'm trying to input a customer number on sheet 1 to lookup the customer name...
Try changing the formula to: =VLOOKUP(C5&"",Sheet2!$A$2:$D$3100,2,FALSE)
Thanks. That helped.
I think there's something wrong with my data file format on the numbers. Some of them will not display when entered and others still will.
Example: the following data cells work - 1, 10
The following data cells don't work - 100, 1000
not sure if they are formatted funny.
- Part of your numbers are treated as text by Excel. Select all of them and choose Data, Text to columns and click Finish. Then use your original formula.
