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.
Category: Lookup and reference
Looks up values in a vector or array
LOOKUP(lookup_value, lookup_vector, [result_vector])
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM