M
Ms. Latte
AA 28 29 30 31 32 33 34
BB XS S M L XL XXL
This is the size chart. AA is the code of size, some code is count by 28 29
etc, some code is in SML.
Then in the same sheet, I have to report that which size and how many pcs
that I have my product in stock. What I do it in very manual way, is I look
at the size code and go back to size chart and copy the size in the the cell.
What I want is that when I type only AA in cell A10 , I would like to
extract 28 29 30 31 etc into B10 B11 B12...........
For example:
size code
AA 28 29 30 31 32 33 34
quantity 5 pcs 5 pcs 4 pcs 5 pcs
Kindly help it could save my time cause I have do it to 1000 products in a
time.
Many thanks
BB XS S M L XL XXL
This is the size chart. AA is the code of size, some code is count by 28 29
etc, some code is in SML.
Then in the same sheet, I have to report that which size and how many pcs
that I have my product in stock. What I do it in very manual way, is I look
at the size code and go back to size chart and copy the size in the the cell.
What I want is that when I type only AA in cell A10 , I would like to
extract 28 29 30 31 etc into B10 B11 B12...........
For example:
size code
AA 28 29 30 31 32 33 34
quantity 5 pcs 5 pcs 4 pcs 5 pcs
Kindly help it could save my time cause I have do it to 1000 products in a
time.
Many thanks