Data validation

[siddharth12]

i am trying to build my own invoice and inventory management system on excel. i have over 1200 products without unique codes. these products also have different variations (color , size ) . how do i set up data validation while i am filling out my invoice form ??i can assign a unique code for a product but not all its variations as they keep changing... please refer to the attached picture for a sample of the product list... please help i am trying to build this for weeks .

 

[Yongle]

"I can assign a unique code for a product but not all its variations as they keep changing"
You cannot validate anything if not in the database to validate against

Are you manufacturing these items yourself or buying them in?

 

[siddharth12]

"I can assign a unique code for a product but not all its variations as they keep changing"
You cannot validate anything if not in the database to validate against

Are you manufacturing these items yourself or buying them in?

i am buying them in . but they do not come with a code...

 

[Yongle]

The list includes ...
- Pluto Regular Brown
- Pluto Regular Ivory
- Pluto Regular White

You state that you have 1200 product..
Do you consider the above 3 items
... 1 product with 3 variations OR .... 3 products ?

 

[siddharth12]

The list includes ...
- Pluto Regular Brown
- Pluto Regular Ivory
- Pluto Regular White

You state that you have 1200 product..
Do you consider the above 3 items
... 1 product with 3 variations OR .... 3 products ?

i consider this as 1 product with 3 variations .

 

[Yongle]

Let me explain what I am trying to establish ..
Assume for the moment that Pluto Regular Red is NOT a valid option for the product
- is there anything, anywhere in your workbook, that we ask Excel to look up to determine if it is listed ?