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