From the course: Excel: VLOOKUP and XLOOKUP for Beginners
Find data quickly in Excel - Microsoft Excel Tutorial
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.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.