software

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,))),quot;quot;,INDEX(A1:C3,MATCH(D2,A1:A3,),MATCH(E1 ,A1:C1,)))

Thanks in advance

quot;Bob Phillipsquot; wrote:

gt; Public Function myLookup(lookup_value, _
gt; table_array As Range, _
gt; col_index_num As Long, _
gt; Optional range_lookup As Boolean = True)
gt; Dim tmp
gt; On Error Resume Next
gt; tmp = Application.VLookup(lookup_value, table_array, col_index_num,
gt; range_lookup)
gt; On Error GoTo 0
gt; If IsError(tmp) Then
gt; myLookup = quot;quot;
gt; Else
gt; myLookup = tmp
gt; End If
gt; End Function