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