I used the TRIM Funtion, thank you gentlemen for your help!!!


"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!