Data Analysis, Microsoft Office VLookup: If cell is empty, return no text August 28, 2018 / =IF(LEN(A4)=0,””,VLOOKUP(A4,contact,7,FALSE)) =IF(ISNA(Vlookup(formula)),””,VLOOKUP(formula))
