IUPUI

Excel: Looking Up Data with VLOOKUP & Using Conditional Functions

This workshop will explore arrays and conditional functions used to summarize or count data with certain criteria. Discover how to use IF and Nested IF functions to test for specific conditions and how to apply different types of conditional formats. Participants will also explore various techniques looking up values in a range of data using VLOOKUP.

Participants will:

perform calculations using array formulas

create IF and nested IF functions

use conditional functions to summarize or count data

use the CONCATENATE function to join text

look up data using VLOOKUP

apply different types of conditional formatting

The following workshops are suggested prerequisites to this workshop:

Excel: Data Management

Participants should already be able to:

create and manage named ranges

create formulas and functions

create and apply validation criteria

work with tables

sort and filter data