The LOOKUP Function
Use LOOKUP when you need to find something in a single row or column and find a value from the same position in a second row or column.
Use LOOKUP when you need to find something in a single row or column and find a value from the same position in a second row or column.
From all the lookup functions, LOOKUP is the least useful. Even though it is a powerful function, it is hardly used at all.