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...
=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...