Excel 2007 : VLookup with ranges

[AMFISH]

I am trying to look up a code when the item number is found on a separate sheet it is not working, I have uploaded it can someone take a look?
Thank you.

[tom1977]

hi
In tab Item in column A you have spacebar " " in every cell (remove this with e.g. trim function and will be ok)

[AMFISH]

thank you so much, that worked fine for that cell but when I copied the formula down to the next cell it is not working

[tom1977]

select column A and run such code (it will remove spacebars and Vlookup will work properly)

Please Login or Register  to view this content.

[AMFISH]

It is all working now. Thank you for your help