Please enable JavaScript to view the comments powered by Disqus.


LOOKUP(...C12,C4:C10,D4:D10)

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

Syntax

LOOKUP(lookup_value, lookup_vector, [result_vector])

Lets chat on this