| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
