Data validation drop down list for mac configuration

New 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

M1 

M2

 

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