I have looked all over and tried a bunch of different things and non are working.
I can get the error to show -
but I also want a blank cell to return -
.
Right now blank cells are returning 0
.
The blank cells appear in the $C$6:$DD$50
section if that helps.
=IFERROR(INDEX('Foundation Plates'!$C$6:$DD$50,MATCH($C9,'Foundation Plates'!$B$6:$B$50,0),MATCH(D$8,'Foundation Plates'!$C$5:$DD$5,0)),"-")
=Index(...) & “”
it would convert 0 (Blank value) to an empty string.