Please enable JavaScript to view the comments powered by Disqus.


How to use LOOKUP() function to look for values.

The formula looks for a values given as the first argument in a range and retrieves the corresponding value from the third argument i.e the resultant range. 

Used Functions

Category: Lookup and reference

Looks up values in a vector or array


LOOKUP(lookup_value, lookup_vector, [result_vector])

Lets chat on this