Posted to microsoft.public.excel.worksheet.functions
|
|
Vlookup not working
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
|