Help with adding blank handling to IF INDEX MATCH?

[slam]

Could someone help me add a condition to this array formula where if the corresponding value in C3:C34 is blank, a blank "" is displayed? Currently it's displaying a 0 if C3:C34 is blank.

=IF(C3<>"",IFERROR(INDEX(INDIRECT("'"&B3&"'!C3:C34"),MATCH(D3,INDIRECT("'"&B3&"'!B3:B34"),0)),""),"")

Thank you

 

[Mike LH]

Hi,

The formula isn't an array formula.

This would work but if you're looking up numeric values they would be returned as text strings.

=IF(C3<>"",IFERROR(INDEX(INDIRECT("'"&B3&"'!C3:C34"),MATCH(D3,INDIRECT("'"&B3&"'!B3:B34"),0)),""),"")&""

Failing that you could go for a longer construct like this

=IF(LEN(IF(C3<>"",IFERROR(INDEX(INDIRECT("'"&B3&"'!C3:C34"),MATCH(D3,INDIRECT("'"&B3&"'!B3:B34"),0)),""),""))=0,"",IF(C3<>"",IFERROR(INDEX(INDIRECT("'"&B3&"'!C3:C34"),MATCH(D3,INDIRECT("'"&B3&"'!B3:B34"),0)),""),""))