(12) How to use LOOKUP formula in Microsoft Excel.
LOOKUP: The LOOKUP function returns a value either from a one-row or one-column range or from an array.
=LOOKUP(lookup_value, lookup_vector, [result_vector])
Example-1: Generally we use lookup formula when we need one data at rapidly. First make a list of your data. Remember that your "lookup_vector" range must be in ascending order (see F2:F5 range).
| Formula |
Description |
Result |
| =LOOKUP(A2,F2:F5,G2:G5) |
Find A2 value in lookup_vector & give the result of result_vector.
here, A2=Green, lookup_vector=F2:F5, result_vector=G2:G5. |
5.77
|
Video:
How to use LOOKUP formula in Microsoft Excel:
|