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
