Forum Discussion
Scanner Inventory with Excel
Greetings, I am trying to correlate my inventory with excel and a scanner. I have my inventory items in an excel file and a USB scanner to scan the products. The scanner will output the physical inve...
Hello, you can extract the UPC code by taking everything to the left of the comma, for example
=left(A1,find(",",A1)-1)
This can be plugged into a lookup formula, for example
=vlookup(left(A1,find(",",A1)-1),$B$2:$D$200,3,false)
The most important thing here is that the lookup value and the first column of the lookup table must be the same data type, i.e. the LEFT() function returns text and the Vlookup will only work if there are exact matches of that text in the lookup table.