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.
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.
hi
In tab Item in column A you have spacebar " " in every cell (remove this with e.g. trim function and will be ok)
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
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
select column A and run such code (it will remove spacebars and Vlookup will work properly)
![]()
Please Login or Register to view this content.
It is all working now. Thank you for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks