Lookup and reference functions

Lookup functions in Excel are mostly for looking up values in a specified range and returning a related value. They are very useful for working between two tables or finding content related to a given value while reference functions are for manipulating cell references.

In this section, we will cover the following important lookup and reference functions in Legacy Excel:

• VLOOKUP
• HLOOKUP
• INDEX
• MATCH
• OFFSET
• INDIRECT
• CHOOSE

The first of these lookup and reference functions that we will cover is VLOOKUP.

VLOOKUP

VLOOKUP is an Excel function for looking up a value in a table and returning a related value in one of the table’s columns. Its syntax is VLOOKUP(lookup_value,table,column_value_to_return,exact_or_approximate), where the value to look up is the first input, followed by the table to search in, then the column position of the value to return and, finally, whether to do an exact match (FALSE) or...