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.
In this 60-minute session, delivered live on YouTube, I show you how to use Excel’s lookup functions to improve the accuracy and integrity of your workbooks, save a ton of time and minimise data entry errors.
The session covers VLOOKUP, HLOOKUP, XLOOKUP, INDEX and MATCH
Links to the video and individual sections below…
The VLOOKUP Function with Exact Match
The VLOOKUP Function with Approximate Match
Using INDEX and MATCH to Retrieve From a Column to The Left