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)

Tony Bender wrote:
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

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



"Tony Bender" wrote in message
ups.com...
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

Look at Debra Dalgleish's site for troubleshooting your =vlookup() formula:
http://contextures.com/xlFunctions02.html#Trouble

Tony Bender wrote:

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

--

Dave Peterson