Data validation drop down list for mac configuration

Copper Contributor

How do I create a linked drop down list with data validation so that it only accepts certain values based on the selection of the previous value? for example


macbook air has 2 chipsets




and for example lets say under M1 --> 8GB ram, 16 GB ram

and under M2 --> 32 GB ram, 64 GB ram 


This is just an example, but How do i create such a list and furthermore, after that I want it to list a price for these 2 selected properties.. How can I do that in excel 365 ? Thank you

1 Reply