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 |
5 comments:
Sir, can you tell how $33 comes in result box
It is the average of all the prices which equals to 32.39, which is roughly 33.00.
You are looking for price for the part number 126
Okay sir! Got it
Thank you
Post a Comment