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.
Thank you
Code:
=IF(C3<>"",IFERROR(INDEX(INDIRECT("'"&B3&"'!C3:C34"),MATCH(D3,INDIRECT("'"&B3&"'!B3:B34"),0)),""),"")
Thank you