IF?

[shapper]

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

 

[BobS]

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]

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

Thank You,
Miguel

 

[Bob Umlas]

In Excel 2007:
=10 + IFERROR(INDEX(B$47:K$52;MATCH($E3;B$47:B$52;0);3),0)