Excel 2016 – 3.7.11 – VLOOKUP with IFERROR

When VLOOKUP can’t find the value it is looking for, it produces the #N/A error. We’re going to see how we can use that error value in the IFERROR function.

Previous

Excel 2016 - 2.9.1 - Create a Table
Next

Excel 365/2016 - 2.11-5.1 - Dynamic Array using IF