IFERROR won't display a blank cell

[jmcole]

I am using this formula, but if the referenced cell is blank, it keeps putting a 0 in the cell. I want the cell to be blank if the referenced cell is blank.

=IFERROR(INDIRECT($E$1&"!$C4"),MATCH(INDIRECT($E$1&"!$C4"),""))

Thanks

[FDibbins]

That will only pick up errors, a blank cell is not (necessarily) an error. Try this...

=if(INDIRECT($E$1&"!$C4"),MATCH(INDIRECT($E$1&"!$C4")=0,"",IFERROR(INDIRECT($E$1&"!$C4"),MATCH(INDIRECT($E$1&"!$C4"),"")))

[jmcole]

That will only pick up errors, a blank cell is not (necessarily) an error. Try this...

=if(INDIRECT($E$1&"!$C4"),MATCH(INDIRECT($E$1&"!$C4")=0,"",IFERROR(INDIRECT($E$1&"!$C4"),MATCH(INDIRECT($E$1&"!$C4"),"")))

That brought back FALSE.

[Richard Buttrey]

Perhaps

=IF(INDIRECT($E$1&"!$C4")=0,"",IFERROR(INDIRECT($E$1&"!$C4"),MATCH(INDIRECT($E$1&"!$C4"),"")))

[jmcole]

Perhaps

=IF(INDIRECT($E$1&"!$C4")=0,"",IFERROR(INDIRECT($E$1&"!$C4"),MATCH(INDIRECT($E$1&"!$C4"),"")))

Thank You Sir, that works perfectly.

[Tony Valko]

What type of data does the formula normally return? Is it text? Numeric? Could be both? Something else?

EDIT: Hmmm...

Not sure I follow the logic of your formula:

=IFERROR(INDIRECT($E$1&"!$C4"),MATCH(INDIRECT($E$1&"!$C4"),""))

What is the 1st instance of INDIRECT($E$1&"!$C4") supposed to be doing? I assume E1 is a sheet name so it'll return the value of SheetName!C4. If that generates an error then the formula will execute the MATCH function.

What is the MATCH function supposed to be doing?

[Richard Buttrey]

EDIT: Hmmm...

Not sure I follow the logic of your formula:

What is the MATCH function supposed to be doing?

@Tony,

I wondered that too.

I assume the OP knows what they want .

[Tony Valko]

@Tony,

I wondered that too.

I assume the OP knows what they want .

Yeah, sometimes it's hard to decipher a formula when no explanation is included!

[jmcole]

What type of data does the formula normally return? Is it text? Numeric? Could be both? Something else?

EDIT: Hmmm...

Not sure I follow the logic of your formula:



What is the 1st instance of INDIRECT($E$1&"!$C4") supposed to be doing? I assume E1 is a sheet name so it'll return the value of SheetName!C4. If that generates an error then the formula will execute the MATCH function.

What is the MATCH function supposed to be doing?

You are both correct, thank you for pointing that out. I didn't need MATCH at all.

[Tony Valko]

Good deal. Thanks for the feedback!