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