Channel: Leila Gharani
Category: Education
Tags: excel tips and trickslookupmicrosoft excel tutorialsvlookupexcel for analystsmicrosoft excellookup exact matchxelplusvisleila gharaniadvanced excel tricksexcel 2016excel lookuplookup functionexcel 2019xelplusmicrosoft 365excel 2013excel online coursexlookupadvanced xlookupexcel 365lookup for engineers
Description: 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. 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 βΊ xelplus.com/courses β― DOWNLOAD the workbook here: xelplus.com/excel-lookup-function π¬ LINKS to related videos: - 10 Excel Functions For Engineers: youtu.be/WjtuWcZnUF8 - How to Use the NEW & IMPROVED Excel XLOOKUP: youtu.be/4c0CLUER6nw π Get the Official XelPlus MERCH: xelplus.creator-spring.com π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz π Excel RESOURCES I Recommend: xelplus.com/resources π₯ GEAR I use: xelplus.com/resources/#gear More resources on my Amazon page: amazon.com/shop/leilagharani π©Letβs connect on social: Instagram: instagram.com/lgharani Twitter: twitter.com/leilagharani LinkedIn: at.linkedin.com/in/leilagharani π 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