Vlookup not working

T

Tbram

I have very simple workbook with a Main worksheet and a reference worksheet
and the vlookup gives me a #na. I have tried changing text to numbers and
vice versa and it wont give me the value. Any help would be appreciated -
below is what i have for a formula????

Main worksheet
A B
2 Customer ID Customer Name
3 1109.00 =VLOOKUP(A3,Customers!$A$2:$B$92,2,FALSE)

Customers Worksheet
A B
1 Customer ID Customer
2 1234 ABC
 
M

Max

.. =VLOOKUP(A3,Customers!$A$2:$B$92,2,FALSE)

Try making the numeric lookup value in A3 as text, viz.:
=VLOOKUP(A3&"",Customers!$A$2:$B$92,2,FALSE)
 
Top