Hello everyone,
I am creating a document at my work. It is a little complex and I'm having trouble finding a way through it.
I will try to explain what it is supposed to do:
Imagine a Shoe Store.
The Excel table would act as a way for customers to filter down to more specific products.
Cell A1 (dropdown list):
Men's Shoes
Women's Shoes
Cell A2 (dropdown list based on A1)
If Men's Shoes chosen on A1, shows:
-- Black
-- Brown
If Women's Shoes chosen on A1, shows:
-- Scarlet
-- Golden
Cell A3 (dropdown list based on A2)
If Men's Shoes, Black:
-- Shoe 1
If Men's Shoes, Brown:
-- Shoe 2
If Women's Shoes, Scarlet:
-- Shoe 3
If Women's Shoes, Golden:
-- Shoe 4
As each cell depends on the value of the previous, what formula could I use on this?
"IF" and "VLOOKUP"?
If anyone could point me in the right direction, like, which formula might be able to do that, I'd be very grateful.
Thank you very much.
Bookmarks