Working with Lookup Functions

• VLOOKUP – returns a value from any cell on the same row when given the value in the first column
• HLOOKUP – returns a value from any cell in the same column when given the value in the first row
• INDEX - returns a value or the reference to a value from within a table or range
• MATCH - returns the relative position of an item in a specified range