Description
Gain indepth knowledge of the LOOKUP functions in Excel.
How do I look up a value in list ONE and pick up a related value from list TWO? How do I avoid my lookup formula displaying an ugly error when it cant find a match? Ive heard of VLOOKUP, but what are HLOOKUP and XLOOKUP? You can get the answers to these questions (and more) by attending this training session dedicated to mastering the various lookup functions that are built into Excel. VLOOKUP, HLOOKUP, and XLOOKUP are some of the most wellknown (and most useful) formulas in Excel. Used properly, they will help you improve the accuracy and integrity of your Excel workbooks, save a ton of time, and minimize data entry errors. 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 topic is relevant for users of all versions of Excel (Note XLOOKUP is only available in certain versions of Excel.)
Date: 2023-04-26 Start Time: 1:00 PM ET End Time: 2:05 PM ET
Learning Objectives
* You will be able to identify how to construct and use the LOOKUP function.
* You will be able to explain how to avoid the lookup formula displaying an ugly error when it cant find a match.
* You will be able to describe the HLOOKUP and XLOOKUP functions.
* You will be able to discuss the difference between VLOOKUP and INDEXMATCH.