Subscriber only lesson.
Sign up to this course to view this lesson.
LOOKUP Part 2
Discover how to use LOOKUP function in a formula.
When to use
The array form of LOOKUP looks in the first row or column of an array for the specified value and returns a value from the same position in the last row or column of the same array.
- The syntax for LOOKUP is as follows:
- Lookup_value is the value that LOOKUP searches for in an array. The Lookup_value argument can be a number, text, a logical value, or a name or reference that refers to a value
- Array is the range of cells that contains text, numbers, or logical values that you want to compare with Lookup_value.
- In the example above we want to return the value of Net Assets from Row 9 in Row 18. To do this a LOOKUP function can be used as follows: =LOOKUP(D$14,$D$5:$U$5,$D$9:$U$9)
- The lookup_value is cell ‘D14’ which is the date we want to search for in the lookup_vector
- The lookup_vector is row D5:U5 which is where we want to find the date (cell ‘D14’)
- The result_vector is row D9:U9 – this will search for the last value in the row and return that value (cell ‘F9’ - $1,200.)
Lesson notes are only available for subscribers.