Forum Discussion

JackLou's avatar
JackLou
Copper Contributor
Nov 28, 2023

Dropdown lists: Concatenate values to identify range?

Hey everyone,   I'd like to create a dropdown list that depends on 2 previous entries dropdown lists. I'll use an example of menu options to illustrate my problem!   The first dropdown is binary:...
excel
mathetes's avatar
mathetes
Gold Contributor
Nov 28, 2023

JackLou 

 

I'm attaching a demonstration of what I've called a "cascading" data validation (or drop down). The secondary and tertiary drop downs change based on prior selections. See if that (or something derived from it) would meet your need.