Edit formula so it returns blank value? Not working for some reason right now

[Jyggalag]

Hi all,

I have this formula:

It pulls in data from here:

However,

despite this column being completely empty, it returns the value 0, rather than a blank cell as I have commanded it to.

I have checked the cells in column H and there are nothing there, not even a space, so i do not understand why it will not return a blank value??

please help Thank you!

 

[RoryA]

A reference to a blank cell will be returned as 0. Assuming that the contents would be text, you can simply append "" to the result of your INDEX function to prevent that.

 

[Jyggalag]

A reference to a blank cell will be returned as 0. Assuming that the contents would be text, you can simply append "" to the result of your INDEX function to prevent that.

Thank you Rory!

How do I do that?

My current formula is:

=IF($B3="","",IFERROR(INDEX(INDIRECT("'"&$E3&"'!$H$3:$H$75"),MATCH(1, (INDIRECT("'"&$E3&"'!$A$3:$A$75")=$B3)*(INDIRECT("'"&$E3&"'!$C$3:$C$75")=$E3),0)),""))

But not sure where to put "" ?

I already have it at the end, but obviously that is not working unfortuantely

 

[RoryA]

Like this:

=IF($B3="","",IFERROR(INDEX(INDIRECT("'"&$E3&"'!$H$3:$H$75"),MATCH(1, (INDIRECT("'"&$E3&"'!$A$3:$A$75")=$B3)*(INDIRECT("'"&$E3&"'!$C$3:$C$75")=$E3),0))&"",""))

 

[Jyggalag]

Like this:

=IF($B3="","",IFERROR(INDEX(INDIRECT("'"&$E3&"'!$H$3:$H$75"),MATCH(1, (INDIRECT("'"&$E3&"'!$A$3:$A$75")=$B3)*(INDIRECT("'"&$E3&"'!$C$3:$C$75")=$E3),0))&"",""))

It worked! Amazing!

Thank you so much Rory!! Once again