Hi, I am trying to do a vlookup by UPC code where the lookup file of the UPC codes has the info coded the cells to display 12 digits
Example: UPC code in the formula bar shows: 23063601212 but when you look at the cell it has a leading zero in front of the number: 023063601212
The problem is when I convert this cell from a number to text it doesn't put the zero in front of the number and when I do a vlookup to get the cost for this UPC code it doesn't find it.
how do I keep the leading zero in the cell where the numbers don't have 12 digits into a text so I can properly do my vlookups.
I am attaching the spreadsheets so you can see what I mean.
File#1 - Named: UPC Code with lookup - this is the file I am trying to bring in the current cost so I can compare current pricing to my previous pricing.
File#2 - Named: C Master Inventory file 2018 - this is the file I am trying to pull the current cost from but the UPC code is not converting to text and leaving the leading zero in there when it's missing a digit.
I would appreciate anyone's help who can assist me in being able to pull the data from the master file so I can pull in my current cost into the UPC code with vlookup file.
Thank you!
YR
Bookmarks