Join 400,000+ professionals in our courses here https://link.xelplus.com/ytdallcou...
The LOOKUP function in Microsoft Excel has the ability to return data from any column that you specify, including one to the left of the column you are looking within. Its default behavior makes it useful for solving certain problems in Excel. The problem with this function is that it can return wrong results if it's not used properly. That's why many people use the VLOOKUP function instead of LOOKUP. However once you understand why you're getting wrong results and how the Lookup function really works, you can use it to solve simple to complex lookup tasks in Excel.
⬇ DOWNLOAD the workbook here: https://pages.xelplus.com/lookupfunc...
Key Learning Points:
LOOKUP Basics: Discover the basic usage of the LOOKUP function, including its arguments and how to apply it for simple data like employee bonuses based on salary tiers.
Sorting Requirement: Understand the critical importance of having your lookup vector sorted in ascending order for accurate results.
Advanced LOOKUP: Learn advanced techniques to find hierarchical data, such as immediate parent part numbers in a Bill of Materials (BOM).
Custom Lookup Vectors: Explore how to create custom lookup vectors using a combination of TRUE/FALSE values, errors, and numerical conversions to solve complex problems.
Error Handling: Gain insights into using IFERROR for cases where the LOOKUP function might return errors.
XLOOKUP Alternative: Learn about the newer XLOOKUP function, offering more flexibility and ease, especially for searching last to first within a range.
00:00 How to Use Excel LOOKUP Function
00:39 LOOKUP Basics
04:42 LOOKUP Advanced
10:00 Alternative XLOOKUP
11:21 Wrap Up
My Online Excel Courses ► https://www.xelplus.com/courses/
LINKS to related videos:
10 Excel Functions For Engineers: • 10 Excel Functions You NEED to KNOW a...
How to Use the NEW & IMPROVED Excel XLOOKUP: • How to Use the NEW & IMPROVED Excel X...
➡ Join this channel to get access to perks: / @leilagharani
☕ Get the Official XelPlus MERCH: https://xelplus.creatorspring.com/
Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/coursequiz/
RESOURCES I recommend: https://www.xelplus.com/resources/
Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel