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)

[TABLE="width: 306"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]Area[/TD]
[TD]Aaron[/TD]
[TD]Louise[/TD]
[TD]Mario[/TD]
[/TR]
[TR]
[TD]Brazil[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Egypt[/TD]
[TD][/TD]
[TD="align: right"]5.95[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Holland[/TD]
[TD="align: right"]4.95[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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))))