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)