is there a way to incorporate an if statement and a list? I want to use an
if statement which would allow me to list a group of choices based on what is
selected in a different cell. for example, if i choose "A" from a list in a
cell a1, it will pull only a list defined as "A" in cell a2.