Data Validation with Index Match

Hi Guys hope all is well.

I have attached a spreadsheet for ease of reference.

In a nushell I have two dropdown lists Gender in cell E2 and Ethnicity in cell D2.

Depending on the selection of d2 and e2 I would like cell f2 to display the appropriate figure from the table called Percentage B3:C20

Thanks alot for any help.

Cheers

You could use:

=IFERROR(INDEX($B$3:$C$20,MATCH($D$2,$A$3:$A$20,0),MATCH($E$2,$B$2:$C$2,0)),"")

or given numeric output

=IFERROR(SUMIF($B$2:$C$2,$E$2,INDEX($B$3:$C$20,MATCH($D$2,$A$3:$A$20,0),0)),"")

former more flexible in terms of output data type

Hi D.

Thanks alot for you help, it worked a treat.

I'm still feeling lighted headed after an operation yesterday! jelly and ice cream all day!!