Forum Discussion

LauraJackson's avatar
LauraJackson
Copper Contributor
Jun 30, 2023

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 if it does not find what it is looking for in either the VLOOKUP or the IFERROR?

 

Thank you!

excel
Formulas and Functions

1 Reply

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Jun 30, 2023

    LauraJackson 

    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:

     

Resources