Lookups
Lookup functions allow you to save countless hours checking, retrieving, and matching information from one data file to another.
Your mind uses the Lookup function every time you get a phone number from the directory. Learn how to use that same function in Excel to extract any specific information from a data file even if the file has thousands of rows.
Objectives
Attendees will learn how to:
+ Lookups, VLookups, and HLookups
+ TRUE / FALSE condition in Lookups
+ two way Lookups
+ two column Lookups
+ Match & Index functions as Lookup functions
+ Offset Function with Lookups
+ ISERROR & ISNA functions with Lookups
Downloads
Quickbooks files used in the session:
Lookup-Session.zip