Index Match

**Blake 7** · 05-29-2011, 05:07 PM

Hey guys - am struggling here with an index match which is giving me a head ache!

I have attached the spreadsheet.

I would like to populate AB5 and AC5 based on the drop down in Z and AA5

Thanks for looking

**shg** · 05-29-2011, 05:41 PM

=index($1:$65536, match(z5, $d:$d, 0), match(aa5, $1:$1, 0) + 1)

**tigertiger** · 05-29-2011, 05:48 PM

you try the formula

at AB5
=INDEX($N$3:$X$85,MATCH($Z5,$D$3:$D$85,0),MATCH($AA5,$N$1:$X$1,0))
at AC5
=INDEX($N$3:$X$85,MATCH($Z5,$D$3:$D$85,0),MATCH($AA5,$N$1:$X$1,0)+1)