Good afternoon -
I have a vLookup returning a 0 from a table that contains blanks. I'd like to return a blank if a blank is found instead of the 0.
Here is the current formula I'm using
=IF(ISNA(VLOOKUP(E3,Sheet2!$A$2:D51,4,FALSE)),"",VLOOKUP(E3,Sheet2!$A$2:D51,4,FALSE))
Thanks in advance for any help you may have
I have a vLookup returning a 0 from a table that contains blanks. I'd like to return a blank if a blank is found instead of the 0.
Here is the current formula I'm using
=IF(ISNA(VLOOKUP(E3,Sheet2!$A$2:D51,4,FALSE)),"",VLOOKUP(E3,Sheet2!$A$2:D51,4,FALSE))
Thanks in advance for any help you may have