Ask Your Question

Revision history [back]

Hello @Roly

You can use a Data -> Validity... tool to define allowed entries for each of the three cells where each cell value is based on the previous cell selection. Please find an example spreadsheet attached. It is based on your sample file, I just added some named ranges for better readability and easier understanding what does formulas do. Click on the B1, B2 or B6 cells on the Form sheet and go to Data -> Validity... menu to see an example of using this feature

Hello @Roly

You can use a Data -> Validity... tool to define allowed entries for each of the three cells where each cell value is based on the previous cell selection. Please find an example spreadsheet attached. It is based on your sample file, I just added some named ranges for better readability and easier understanding what does formulas do. Click on the B1, B2 or B6 cells on the Form sheet and go to Data -> Validity... menu to see an example of using this feature

Here you can find an article with more detailed explanation on creating dependent validity lists.

Hello @Roly

You can use a Data -> Validity... tool to define allowed entries for each of the three cells where each cell value is based on the previous cell selection. Please find an example spreadsheet attached. It is based on your sample file, I just added some named ranges for better readability and easier understanding what does formulas do. Click on the B1, B2 or B6 cells on the Form sheet and go to Data -> Validity... menu to see an example of using this feature

Here you can find an article with more detailed explanation on creating dependent validity lists.

Edit 09.01.2019 - updated sample added.