LOOKUP() function

Functions Jun 07, 2019

About  LOOKUP() function

The LOOKUP() function is a lookup and reference function that searches for a specific piece of information in one data vector, and returns a value from the corresponding position of a second data vector.

Where to apply :

This function helps in getting data from master table and to map the data.

Syntax :

=LOOKUP(lookup_value, lookup_vector, [result_vector])

Parameters :

lookup_value - A value that is used for matching data in the table to

lookup_vector - A table or a range wherein lookup_value in searched.

[result_vector] - A table or a range from that is used for getting corresponding result.


Lets take 2 arrays with head like fruit_code and fruit_name like 1, 2, 3 with corresponding fruit names are "Mango", "Apple", "Banana".

=LOOKUP(3,{1,2,3},{"Mango","Apple","Banana"})     // Returns (Banana)

The above function returns Banana since we look 3 in fruit_code to get the corresponding fruit name.

Excel based example:

Lets take a table to understand the use of LOOKUP() function.

Imag 1 - Table

1. From the above we need to get name for the codes mentioned in following table.

Image 2 - LOOKUP() function

The LOOKUP() function is well explained in above image.

Hope, it would have added in your Excel function knowledge.

Thank You!

Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.

If you want to learn Excel & VBA courses to be Excel expert, connect us on:

9599408486 / 8929231250
Website: https://www.excelhour.in/

Manoj kumar

Corporate Trainer at ExcelHour. I have devoted over 9 years to various industries for learning multiple data challenges and trained Excel and VBA courses to the corporate along with offline training.

Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.