Overview

This session will cover more advanced Functions in Excel such as Vlookup and Match and Index to perform more complex lookups of data. Participants should be proficient Excel users.

Duration: 1.5 hours

Method of Delivery: Virtual

Topics:

· When to use a Lookup function

· How to create a formula using the Lookup function

· Vlookup versus Hlookup

· How to check your data

· How to return an exact match

· When and how to use range names in the lookup function

· Branch when errors / non match occurs

· Using the Match function within the Lookup

· Using the Match and Index function instead of lookup

· Which functions to use when more than one lookup is needed