Vlookup not working
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 not working
.. =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 |
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 |
Vlookup not working
Glad you got it working..
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Tbram" wrote in message ... THANK YOU!!!! |
All times are GMT +1. The time now is 01:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com