ISERROR question

[spoko]

Hello

How can I apply (ISERROR) to this function

=INDEX(AuroraR,MATCH(F12,INDEX(AuroraR,,1),0),MATCH(G12,INDEX(AuroraR,1,),0))
Thanks

[VBA Noob]

Try

=IF(ISERROR(INDEX(AuroraR,MATCH(F12,INDEX(AuroraR,,1),0),MATCH(G12,INDEX(AuroraR,1,),0))),"",INDEX(AuroraR,MATCH(F12,INDEX(AuroraR,,1),0),MATCH(G12,INDEX(AuroraR,1,),0)))

VBA Noob

[daddylonglegs]

Assuming the error you expect is #N/A caused by no MATCH try

=IF(ISNUMBER(MATCH(F12,INDEX(AuroraR,,1),0)*MATCH(G12,INDEX(AuroraR,1,),0)),INDEX(AuroraR,MATCH(F12,INDEX(AuroraR,,1),0),MATC H(G12,INDEX(AuroraR,1,),0)),"")

[spoko]

Thanks guys, works perfect.