Formula Assistance

[Arts]

Hi all

I did an Index match formula which for all intents and purposes works. INDEX(G16:P25,MATCH(T17,F16:F25,FALSE),MATCH(S17,G15:P15,FALSE))
I look up an individuals name across data (sample copied in below)

Area	Aaron	Louise	Mario
Brazil
Egypt		5.95
Holland	4.95

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

The initial issue I had which I managed to solve was if I was to type in the name "Louise" against "Egypt" this would return me 0. So I tailored the formula as

=IF(INDEX(G16:P25,MATCH(T17,F16:F25,FALSE),MATCH(S17,G15:P15,FALSE))=0,"No Value",INDEX(G16:P25,MATCH(T17,F16:F25,FALSE),MATCH(S17,G15:P15,FALSE)))

Is there a way I can include an ISNA aspect within the formula as well? So if I was to type in "Harry" against "Egypt" where a "N/A" is thrown up instead of a zero this can be caught as well?

Thanks
Arts

 

[Arts]

After mixing up the order I came up with the following formula (By having the ISNA first, I was attempting to place this within the second if at first) which seems to work. Not the most efficient of formulas so if there is a more efficient way please post otherwise the below seems to work for me

=IF(ISNA(INDEX(G16:P25,MATCH(T17,F16:F25,FALSE),MATCH(S17,G15:P15,FALSE))),"Error",IF(INDEX(G16:P25,MATCH(T17,F16:F25,FALSE),MATCH(S17,G15:P15,FALSE))=0,"No Value",INDEX(G16:P25,MATCH(T17,F16:F25,FALSE),MATCH(S17,G15:P15,FALSE))))