Vlookup

[MattB]

Hi all

I seem to have an incredibly frustrating problem with VLookups. I rely on it as I need to analyse thousands of part codes, yet I just don't seem to be able to trust it.
I have taken a sample from the 2 s/sheets concerned where I'm attempting to look up a cost for a part code when the code exists in the other s/s. It returns a #n/a to me when it's blatantly obvious that the code does exist. I suspect some sort of formatting difference but I can't seem to find it myself.
Could anybody take a look or does anybody know what it could be??
Thanks

Matt

 

[Anne Troy]

Matt:

Check out the *Dreaded* Vlookup at:

http://www.thewordexpert.com/tipwarez.htm#MyVlookup

It probably explains your problem too.

 

[Mark W.]

Matt, the data type matters!!!

"17863" <> 17863

 

[MattB]

Mark

Couldn't be a little more specific could you!?

 

[Ricky Morris]

there might be spaces after the numbers and/or letters in your source and not in your destination, or vice versa that might not be visible. Use the trim function to remove these space if they exist.