Lookup

[mjfox62]

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 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.

Any suggestions?

[#2]

Try changing the formula to: =VLOOKUP(C5&"",Sheet2!$A$2:$D$3100,2,FALSE)

[#3]

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.

[#4]

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.