Excel Lookups and Moving Beyond VLOOKUP (Currently Unavailable)

Author: Jeff Lenning

In this session, we'll discuss lookups and dig into the many subtle details of the VLOOKUP function.

Even though this function is quite capable, it does have limitations. We'll discuss related workarounds, and ultimately, learn how to move beyond VLOOKUP all together.

Note: this course is designed for Microsoft Excel for Windows, and selected items may not be available in Excel for Mac.

Publication Date: June 2014

Designed For
Accounting professionals looking to learn more about Microsoft Excel for Windows.

Topics Covered

• Lookup Basics
• Improving VLOOKUP with MATCH
• Improving VLOOKUP with VALUE and TEXT
• Moving Beyond VLOOKUP with INDEX

Learning Objectives

• Recall the arguments of the VLOOKUP function
• Identify the function that returns the relative position of a list item
• State the arguments of the INDEX function

Level
Intermediate

Instructional Method
Self-Study

NASBA Field of Study
Computer Software & Applications (2 hours)

Program Prerequisites
be familiar with basic excel functions, named references, tables, data validation, conditional formatting, SUBTOTAL, skinny row, cell styles, nested functions, conditional summing, and remove duplicates.

Advance Preparation
None