Overview
Imagine the tedious task of manually scanning through a lengthy column in an Excel workbook, searching for a specific value like "Client Number A123-6TD8G" or "Employee Number 46487209765," and then navigating 21 columns to the right to find associated information such as "Client Spend this year" or "Employee’s Manager." Not only is this process time-consuming, but it's also highly prone to errors.
Enter Excel’s LOOKUP formulas. These powerful functions can accomplish in a fraction of a second what would take minutes to do manually, ensuring accurate results every time.
Learning how to use Excel’s Lookup functions will help you to improve the accuracy and integrity of your Excel workbooks, save a ton of time and minimize data entry errors.
Areas Covered
· VLOOKUP v HLOOKUP v XLOOKUP: What’s the difference and when should I use each one?
· How to construct and use the LOOKUP functions
· Convert your Lists to Tables – the key to future-proofing LOOKUP
· How to avoid your LOOKUP functions displaying #NA
· What are INDEX and MATCH and how do they differ from LOOKUP functions
Who Will Benefit
This training is categorized as intermediate and is aimed at users who want to learn about the Lookup functions in Excel.
Although the training will be delivered using the latest version of Excel, this training is relevant for users of all versions of Excel. However please check whether your version of Excel includes XLOOKUP as it is only available in certain versions of Excel.
