try

=10 +
if(ISNA(INDEX(B$47:K$52;MATCH($E3;B$47:B$52;0);3)) ,0,INDEX(B$47:K$52;MATCH($E3;B$47:B$52;0);3))


"shapper" wrote in message
...
Hello,

I have the following:

=10 + INDEX(B$47:K$52;MATCH($E3;B$47:B$52;0);3)

I get #N/A when there is not match.

How can I change it to have 10?

Thanks,
Miguel