Excel Lookup Functions in Depth | Video course
Microsoft Excel offers a variety of powerful lookup functions that allow you to easily retrieve information across spreadsheets. In this course, Excel expert demystifies some of the most significant lookup functions. Tune in to learn how to use the new XLOOKUP function, which can handle all the capabilities of the widely used VLOOKUP and HLOOKUP functions, in addition to providing more power and flexibility. Explore uses of the MATCH function and the newer, more robust XMATCH function to match up data, and learn how to extract data using the INDEX function. Discover how to restructure the lists being searched to ensure that you're using each function efficiently, and learn about dynamic array lookup functions like UNIQUE, SORT, SORTBY, and FILTER. Along the way, excel expert shares practical examples that help you grasp how to implement these functions in your workflow
Topics covered | Video Course
01 Locating Data with MATCH, INDEX, and XMATCH Functions
02 VLOOKUP, HLOOKUP, and XLOOKUP
03 Finding Matching Data without Using External Lists
04 Other Functions with Lookup Capabilities
Latest Version
excel_lookup_1Requires Android
6.0 and up
Category
Free Education AppContent Rating
Everyone
Report
Flag as inappropriateLast updated on Jul 21, 2021
Minor bug fixes and improvements. Install or update to the newest version to check it out!
APKPure - A multi-platform app store primarily focused on Android, providing extensive app-related content. Discover the app you want easier, faster, and safer, with quick and efficient downloads and installations.
