Thanks:  0
Likes:  0

1. ## To return blank instead of #N/A

Would anyone be able to help me modify this. I am trying to make it so if the result is #N/A, it will return "" or blank.

=INDEX('Schedule Tool'!\$C\$1:\$BT\$1,MATCH(1,OFFSET('Schedule Tool'!\$D\$2:\$BU\$2,MATCH(A2,'Schedule Tool'!\$A\$3:\$A\$30,0),,1),0))

Thanks everyone in advance for any help

sd

2. ## Re: To return blank instead of #N/A

=IF(ISNA(INDEX('Schedule Tool'!\$C\$1:\$BT\$1,MATCH(1,OFFSET('Schedule Tool'!\$D\$2:\$BU\$2,MATCH(A2,'Schedule Tool'!\$A\$3:\$A\$30,0),,1),0))),"",INDEX('Schedule Tool'!\$C\$1:\$BT\$1,MATCH(1,OFFSET('Schedule Tool'!\$D\$2:\$BU\$2,MATCH(A2,'Schedule Tool'!\$A\$3:\$A\$30,0),,1),0)))

try this

This is a simple IF statement, your original formula is in pink, the new part is in blue.

Statement now reads: If "original formula" returns #N/A, change to ""; else, perform "original formula".

3. ## Re: To return blank instead of #N/A

Originally Posted by Desu Nota from Columbus
=IF(ISNA(INDEX('Schedule Tool'!\$C\$1:\$BT\$1,MATCH(1,OFFSET('Schedule Tool'!\$D\$2:\$BU\$2,MATCH(A2,'Schedule Tool'!\$A\$3:\$A\$30,0),,1),0))),"",INDEX('Schedule Tool'!\$C\$1:\$BT\$1,MATCH(1,OFFSET('Schedule Tool'!\$D\$2:\$BU\$2,MATCH(A2,'Schedule Tool'!\$A\$3:\$A\$30,0),,1),0)))

try this

This is a simple IF statement, your original formula is in pink, the new part is in blue.

Statement now reads: If "original formula" returns #N/A, change to ""; else, perform "original formula".

Thank you soo much, worked perfect!!

4. ## Re: To return blank instead of #N/A

Originally Posted by sdoppke
Would anyone be able to help me modify this. I am trying to make it so if the result is #N/A, it will return "" or blank.

=INDEX('Schedule Tool'!\$C\$1:\$BT\$1,MATCH(1,OFFSET('Schedule Tool'!\$D\$2:\$BU\$2,MATCH(A2,'Schedule Tool'!\$A\$3:\$A\$30,0),,1),0))

Thanks everyone in advance for any help

sd
Also, if the outcome is expected to be text-valued and you are on an Excel version prior 2007...
Code:
```=LOOKUP(REPT("z",255),CHOOSE({1,2},"",
T(INDEX('Schedule Tool'!\$C\$1:\$BT\$1,
MATCH(1,OFFSET('Schedule Tool'!\$D\$2:\$BU\$2,
MATCH(A2,'Schedule Tool'!\$A\$3:\$A\$30,0),,1),0)))))```

5. ## Re: To return blank instead of #N/A

Originally Posted by sdoppke
Would anyone be able to help me modify this. I am trying to make it so if the result is #N/A, it will return "" or blank.

=INDEX('Schedule Tool'!\$C\$1:\$BT\$1,MATCH(1,OFFSET('Schedule Tool'!\$D\$2:\$BU\$2,MATCH(A2,'Schedule Tool'!\$A\$3:\$A\$30,0),,1),0))

Thanks everyone in advance for any help

sd
If you're using Excel 2007 or later...

=IFERROR(INDEX('Schedule Tool'!\$C\$1:\$BT\$1,MATCH(1,OFFSET('Schedule Tool'!\$D\$2:\$BU\$2,MATCH(A2,'Schedule Tool'!\$A\$3:\$A\$30,0),,1),0)),"")

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•