To return blank instead of #N/A

[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

 

[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".

 

[sdoppke]

=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!!

 

[Aladin Akyurek]

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

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

 

[T. Valko]

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