Microsoft Excel - Look Up, Match and Compare Data
Course Duration: 90 Minutes
Target Audience:
This session is intended for Excel users who wish to manage data records in lists or tables, and need to search for data pertaining to specific search criteria.
Course Objectives:
The Lookup functions in Excel enable you to look up cells content in a separate range of data and return data associated with the matched value. You can use a HLOOKUP, VLOOKUP or XLOOKUP depending on the orientation of the table you are looking up. You can also use a combination of MATCH and INDEX instead of a Look Up function which can be useful for bigger files.
Course Outline:
Introduction and Overview
CONTENT
Creating Lookup Functions
-
When to use a Look Up function
-
How to create a formula using the Look Up function
-
How to check your data
-
How to return an exact match
Using Range Names
-
When and how to use range names in the Look Up function
Using Branching
-
Branch when errors / non match occurs
Additional Features
-
Using the MATCH function within the Look Up
-
VLOOKUP, HLOOKUP and XLOOKUP
-
Using the MATCH and INDEX function instead of a Look Up