[SOLVED] Link result of multiple text dropdowns to one cell

I have a situation where I will have three or four different data validation text dropdown cells. I only expect that one will be selected but need to report the result of all in one cell linked on another page.

I simplified what I am trying to do on the attached sample file.

Thanks if you are able to help with this.

Ken

Use

=INDEX(A1:A3,MATCH(TRUE,A1:A3<>"",0))
Confirm with Ctrl+Shift+Enter and not just Enter
this will give you value on first populated cell from the top

or the simpler
=IF(A1="",IF(A2="",A3,A2),A1)

Or with just ENTER,

=INDEX(B1:B3,MATCH("*",A1:A3,0)) This will return the first value from B1:B3 even if multiple drop down are selected,

=LOOKUP("zzzzz",A1:A3,B1:B3) This will return the last value from B1:B3 even if multiple drop down are selected.

Assuming A1:A3 will be text entries.

So based on your last sample, what is your desired result?

This should work.

=VLOOKUP("*",A1:B3,2,0)

One way is use IF,

=IF(ISNA(VLOOKUP("*",A1:B3,2,0)),"",VLOOKUP("*",A1:B3,2,0))