You are right Mike! I hit F2 in a cell and there are a bunch of spaces after
the part number in one spreadsheet. How can I get rid of these? Thank you!

"Mike H" wrote:

Hi,

The formula is fine so the NA# indicates no match for the data in A2. Usual
culprits are rogue spaces.

Mike

"Sorceressss" wrote:

I have been doing vlookups for years and now I am having problems with it,
can someone please look at this formula and see if anything sticks out as
being wrong? I am getting all #N/A's for results:
=VLOOKUP(A2,'[Talaris Account history by cust part no.
200711-200810.xls]Account History'!$E$8:$E$496,1,FALSE)

Thank you!