Excel: Output based on selection from multiple drop down menus -

Excel: Output based on selection from multiple drop down menus -

i want output 1 of number of options in excel based on selection of several drop downwards menus.

for example, chose specific shirt design number of options based on age, gender, , size of person, 3 variable can selected 3 drop downwards menus, assuming have matrix figure out appropriate options below:

are there functions in excel might utilize accomplish this? or have utilize visual basic?

thanks!

no need vba here, need helper logic , and index/match formula:

the options need unique , have 1 element per alternative grouping per line. in illustration means need split options 5, 6 , 9 each have multiple age groups - see yellowish lines:

you need encode options in way, e.g. 0-4=4, 5-9=9, 10-14=14, male = m, etc.. can translate each of options 1 unique 3 letter text, e.g. alternative 1 4ml. in below example, next formula used build id in cell j3: =index($b$1:$d$1,match("x",b3:d3))&index($e$1:$f$1,match("x",e3:f3))&index($g$1:$i$1,match("x",g3:i3))

you need translate selection drop downs code. formula yellowish cell is: =index($b$1:$d$1,match(m1,$b$2:$d$2,0)) &index($e$1:$f$1,match(m2,$e$2:$f$2,0)) &index($g$1:$i$1,match(m3,$g$2:$i$2,0)) now need translate code alternative using next formula: =iferror(index($a$3:$a$16,match(m4,$j$3:$j$16,0)),"no alternative selection!")

note show little text in case selected alternative not available.

for improve understanding, can find example file here.

excel