ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - IF? (https://www.excelbanter.com/excel-programming/435814-if.html)

shapper

IF?

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

IF?

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

shapper

IF?

On Nov 4, 9:09*pm, "BobS" wrote:
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

Thank You,
Miguel

Bob Umlas[_3_]

IF?

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

"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

All times are GMT +1. The time now is 09:10 AM.