Custom function to simplify Index(match)) formula

M

Martin

Hello,

Do you know how to custom this in the same way that Bob Phillips did:

=IF(ISERROR(INDEX(A1:C3,MATCH(D2,A1:A3,),MATCH(E1,A1:C1,))),"",INDEX(A1:C3,MATCH(D2,A1:A3,),MATCH(E1,A1:C1,)))

Thanks in advance
 
Top