How To Write A Vlookup Formula : The vlookup formula in d5 is configured to perform an approximate match by setting the last argument to true in this video we look at how to replace a typical nested if formula with a vlookup formula.