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 |
No comments:
Post a Comment