Vlookup not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup not working for me. 1
Formula Using Vlookup & Match 3
VLOOKUP and MID Function 9
Match and Vlookup issue 2
Need VLOOKUP to Work Two Ways 0
matching & combining data from seperate worksheets 2
Using ISNA function, but replace the blank cell with text 3
Avoiding redundant calculations 7

Back
Top