Two Critical Excel Functions: VLOOKUP and SUMIFS ON DEMAND

Overview

The VLOOKUP function has long been the reigning champion of Excel’s lookup functions. But the recently introduced SUMIFS function is quite powerful. So which function should we use to perform our lookup tasks? In this session, we’ll dig into this question and see when and how these functions can be used. This course is presented in Excel for Windows. Note: Certain items presented may not be available in all Excel versions, including Excel for Mac, iPad or web.

Highlights

VLOOKUP function. SUMIFS function. VLOOKUP and SUMIFS comparison.

Prerequisites

None.

Designed For

Accountants using Excel for Windows.

Objectives

Identify the differences between VLOOKUP and SUMIFS. Recall the arguments for the VLOOKUP and SUMIFS functions. Recognize the function that can return the sum of all matching values in a range.

Preparation

None.

Notice

None.