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