Trying to surround a vlookup with iferror

[MurphDog]

I updated my vlookup formula to the following so that blank cells (aka date format 1/0/1900) in column 6 return a blank cell.

=IF(LEN(VLOOKUP($I6,$B$5:$G$49,6,0))=0,"",VLOOKUP(I6,$B$5:$G$49,6,0))

It works when there is a value to lookup. But as expected, I get a N/A error when cells in the I column are blank.

Tried adding a IFERROR formula around it but I'm doing it wrong somehow. Please advise.

=IFERROR((LEN(VLOOKUP(I6,$B$5:$G$49,6,0))=0,"",VLOOKUP(I6,$B$5:$G$49,6,0)),"")

I have other if error functions in my spreadsheet that work just fine...

 

[lrobbo314]

How about

=IFERROR(IF(LEN(VLOOKUP($I6,$B$5:$G$49,6,0))=0,"",VLOOKUP(I6,$B$5:$G$49,6,0)),"")

 

[MurphDog]

How about

=IFERROR(IF(LEN(VLOOKUP($I6,$B$5:$G$49,6,0))=0,"",VLOOKUP(I6,$B$5:$G$49,6,0)),"")

Sure enough, that did it. For some reason, i thought I would be replacing the existing IF statement, thinking that by not keeping the existing IF in there, it would automatically default to IF, somehow. I don't know.

Thanks