From the course: Excel: VLOOKUP and XLOOKUP for Beginners

Find data quickly in Excel

- Do you want to make your spreadsheets more interactive than just a basic filter? Or, maybe you want to make yourself more marketable to employees by learning a valuable and extremely popular Excel function. Xlookup and Vlookup are Excel functions that can look up a value in a row or a column and return related data. In a long spreadsheet, you can look up a price based on a part number or a phone number based on a name. Now these functions can be daunting and overwhelming if you don't have a lot of experience using functions and formulas. That's okay. My name is Jess Stratton, and I am so glad you're here because I'm going to show you that Xlookup is not hard to use and incredibly powerful. So let's get started and we'll have some fun together.

Contents