Excel for Accounting Professionals Part V: Error Trapping & Improving Lookups
Overview
This webcast walks through the limitations and suggests how to improve the VLOOKUP function. We spend some time trapping errors with the IFERROR function, which was first rolled out with Excel 2007.