ISNA with INDEX(MATCH) function not working

Try this

=IFERROR(INDEX('TT 2012-13'!D2:D335,MATCH(1,('TT 2012-13'!A2:A335=B4)*('TT 2012-13'!B2:B335="Tues")*('TT 2012-13'!C2:C335="AM"),0)),"")

Wow, stunningly fast response.
Unfortunately the IFERROR bit generates a #name? error.
Thanks anyhow

G

Originally Posted by kvsrinivasamurthy

Try this

=IFERROR(INDEX('TT 2012-13'!D2:D335,MATCH(1,('TT 2012-13'!A2:A335=B4)*('TT 2012-13'!B2:B335="Tues")*('TT 2012-13'!C2:C335="AM"),0)),"")

IFERROR is not available in XL2003.

Pete