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

.. =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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tbram" wrote:
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

THANK YOU!!!!

"Max" wrote:

.. =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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tbram" wrote:
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

Glad you got it working..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tbram" wrote in message
...
THANK YOU!!!!