View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gmata Gmata is offline
external usenet poster
 
Posts: 41
Default 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.