See how to do VLOOKUP with IF statement in Excel and how to use If Isna Vlookup formulas to replace #N/A errors with your own text, zero or blank cell (empty string).