vlookup help

[philb99]

Hi I have been trying to carry out a vlookup but I am getting the #N/A reply. The Column I am looking up has only a Product Code like AA. however when I overtype AA then my vlookup works.

That woud be great but a 3000rosof da o lookup

 

[steve the fish]

You have really answered your own question. The AA you see is not really equal to AA. There is probably as trailing space or something. Click in the cell. Is there a space after the AA?

 

[philb99]

Yes there is, I didn't think / know to look for that one - thanks Steve the fish