Excel's VLOOKUP Function

Course details

VLOOKUP is one of Excel's most useful functions. This course provides an introduction to the VLOOKUP function as well as practical tips for how to use this function to improve the integrity of your spreadsheets, streamline productivity, and decrease accounting errors. We cover the nuances of VLOOKUP, how to counteract missing data with the IFERROR and IFNA functions, and ways to turbo-charge VLOOKUP by incorporating the MATCH function.

This course enables you to:

• Improve the integrity of spreadsheets with Excel's VLOOKUP function.
• Recognize what causes look-up errors, and see how to overcome such situations.
• Understand the new IFNA function available to Excel 2013 users.
• Uncover the limitations of VLOOKUP, along with alternatives.
• Perform dual lookups across columns and down rows to cross-reference the data you need.