Using Lookup Functions and Formula Auditing in Excel 2016: Use Lookup Functions
Interactive

Using Lookup Functions and Formula Auditing in Excel 2016: Use Lookup Functions

Biz Library
Updated Feb 05, 2019
Microsoft Office Excel 2016: Part 3 (Advanced) - Lookup functions search through a particular dataset to return a particular value based on some criteria. Although you could search for data and look up the value yourself, you wouldn't want to do this for multiple records over and over. (INDEX, VLOOKUP, HLOOKUP)