Look up function
LOOKUP
Looks through a sorted row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column.
Sample Usage
LOOKUP(10003, A1:A100, B1:B100)
LOOKUP(10003, A1:B100)
LOOKUP("foo", A1:Z10)
This examples shows the price of part number 126.
Part Number | Price | Formula | Result |
105 | $27.50 | =LOOKUP(126, $A$2:$A$6, $B$2:$B$6) | $33.00 |
126 | $33.00 | ||
133 | $41.75 | ||
171 | $26.75 | ||
188 | $32.99 |
This examples shows when the search_key is not found (student ID 765333), a non-exact match may be returned.
Part Number | Price | Formula | Result |
764541 | B | =LOOKUP(765333,$A$2:$A$5,$B$2:$B$5) | C |
764598 | C | ||
765444 | B- | ||
766765 | A | For look up value must be sorted first |