Forum Discussion
Remove zero value when no value found for Excel formula
Hi everyone, Here is my formula currently =IFERROR( VLOOKUP([@[Color]],BH:BP,3,FALSE), $AI2) I am seeing a zero when it does not find a value. Is there a way to have it leave the field blank...
I might need to see the sheet, but this may work for you:
=LET(results,IFERROR(VLOOKUP([@[Color]],BH:BP,3,FALSE),$AI2),IF(results=0,"",results))
Another option would cell formatting as such: