Vlookup Problems

  • Thread starter Thread starter Tony Bender
  • Start date Start date
T

Tony Bender

I have two tables with store sales data, the common field is the store
number. In both tables the store number is formatted as General.
When I attempt a vlookup I get NA's, yet when I do a 'Find' it works
fine. How can this be?

TIA
 
I've run into that numerous times. I have now started using a Text
function within the Vlookup function and haven't had any problems.
=VLOOKUP(TEXT(A2,"@"),'Sheet3'!A:B,2,FALSE)
 
You probably have text values, you can't change that by just changing the
format, it will still be text.
Also look for trailing leading spaces.

To test if there are extra characters use

=LEN(lookup_value)


then test one of the values that find finds

=LEN(Sheet2!A4)


the formulas should return the same number


If you get the same number then the values in the lookup table are text,
then you can wrap the lookup value in the TEXT function like in the example
that was posted to this thread


--


Regards,


Peo Sjoblom
 
Back
Top