How Can I Assign an Specific Code to every Product
Thanks i think thats exactyly what i need a vlookup formula
But how would the formula be if i have for example:
A
B
1000 Perfume by Jean Patou for Women -- Body Lotion 6.7 oz FE0003
12 Cologne by Jean Couturier for Men -- EDT Spray 3.3 oz FE0004
1881 Amber Cologne by Nino Cerruti for Men -- EDT Spray 1.7 oz FE0005
1881 Cologne by Nino Cerruti for Men -- After Shave Balm 3 oz FE0006
1881 Cologne by Nino Cerruti for Men -- EDT Spray 0.83 oz FE0007
1881 Cologne by Nino Cerruti for Men -- EDT Spray 3.3 oz FE0008
1881 Cologne by Nino Cerruti for Men -- EDT Spray 6.8 oz FE0009
how can i look up the info on "B" column with the product description.
|