Use LOOKUP when you need to look in a single row or column and find a value from the same position in a second row or column.
For example, let’s say you know the part number for an auto part, but you don’t know the price. You can use the LOOKUP function to return the price in cell H2 when you enter the auto part number in cell H1.
Lesson 1 : Working with Array Formulas
Lesson 2 : Using The VLOOKUP Function
Lesson 3 : Using the Advanced Function