If you've ever needed to manually search through a list of items for a specific value, you'll know how time-consuming it can be, not to mention the risk of returning the wrong value because your search term wasn't quite right or the time wasted if the value you're looking for isn't there.
Learn how to use Excel's lookup functions and improve the accuracy and integrity of your workbooks to save a ton of time and minimise data entry errors.
In this live session you'll learn, using real-life examples, how to use VLOOKUP, HLOOKUP, XLOOKUP, INDEX and MATCH
This training is categorised as intermediate and is aimed at users who want to learn about the Lookup functions in Excel
⏱ Timestamps
00:00:00 Introduction
00:00:45 The VLOOKUP Function with Exact Match
00:11:08 The VLOOKUP Function with Approximate Match
00:19:39 The HLOOKUP Function
00:23:19 The MATCH Function
00:27:03 The INDEX Function
00:32:47 Using INDEX and MATCH to Retrieve From a Column to The Left
00:37:41 Using INDEX and MATCH to Retrieve the Next Largest Value
00:43:17 The XLOOKUP Function
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at [ Ссылка ]
🙋♂️ Let's connect on social
Twitter: [ Ссылка ]
Facebook: [ Ссылка ]
LinkedIn: [ Ссылка ]
#excel #lookup
![](https://i.ytimg.com/vi/uwTI5pTxN20/maxresdefault.jpg)