Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an Online Store and the problem i have is that i don't have SKU for
the products i have making it extremly hard to keep track of every product. So i need to assign an specific code to each product and be able to type the name of a product and get the code automaticly on another Column. This is an example of products i have: Ck Be Perfume by Calvin Klein for Women -- Body Lotion 1.7 oz Arden Beauty Perfume by Elizabeth Arden for Women -- Body Lotion 1.7 oz Celine Dion Perfume by Lancaster for Women -- Body Scrub 6.7 oz So i need that every time i put Ck Be Perfume by Calvin Klein for Women -- Body Lotion 1.7 oz i get a code "FE6789" as an example is this possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assign a code to a range of time | Excel Worksheet Functions | |||
where is the product code for operating cd | Setting up and Configuration of Excel | |||
ENTER PRODUCT # AND HAVE assign DESC. & COST in invoice | New Users to Excel | |||
Capture first 2 letters from a product code | Excel Worksheet Functions | |||
Cleaning Product Code list | Excel Worksheet Functions |