LOOKUP
LOOKUP can search a one-row or one-column range and return a corresponding value.
Syntax
=LOOKUP(lookup_value,lookup_vector,result_vector)
Example:
|
Marks |
Grade |
|
40 |
C |
|
60 |
B |
|
75 |
A |
|
90 |
A+ |
=LOOKUP(82,A2:A5,B2:B5)
Result: A
LOOKUP is particularly useful when the lookup values are arranged in ascending order.
INDEX
INDEX returns a value from a specified position in a range.
Syntax
=INDEX(array,row_num,[column_num])
Example:
|
Employee |
Department |
|
Amit |
Sales |
|
Neha |
HR |
|
Rahul |
IT |
=INDEX(B2:B4,3)
Result: IT