Hello i have the formula below and it is referencing another cell on another sheet, and when that cell does have info in it the formula does what it needs to. However, when that cell it is referencing in 'List' is empty the formula is placing a '0' which i would rather it be blank still and not a 0 when the referenced cell is blank
any assistance would be appreciated
=IFERROR(INDEX('List'!$E:$G,MATCH('Info'!D$4,'List'!$G:$G,0),1),"ERROR")
any assistance would be appreciated
=IFERROR(INDEX('List'!$E:$G,MATCH('Info'!D$4,'List'!$G:$G,0),1),"ERROR")