Lookup and Reference function

LOOKUP:This function is used to return the value form one row or one column range. This function is similar to other lookup function such as VLOOKUP, HLOOKUP in that it can be used to return a value from a range in Microsoft Excel 2010 and 2013.

There is two syntax of Lookup function

=LOOKUP(lookup_value,array) =LOOKUP(lookup_value,lookup_vector,[result_vector])

Uses of lookup Function                    

We use this function to pick the values from one data to another, but the condition is we should have the common values in both data’s so we can easily pick the value.

Let’s take an example and understand how and where we can use Lookup function in Microsoft Excel 2010 and 2013.

=LOOKUP(lookup_value,lookup_vector,[result_vector])

Example 1: We have 2 data sets. In which we have require joining date from 1st data to 2nd data.
 
img1
 
To pick the value from 1st data to 2nd data we have common value is Emp. Code, So we will put the Lookup function through Emp. Code follow below mentioned steps to pick the joining date:-

  • Select the cell C9 and write the formula.
  • =LOOKUP(C8,$C$2:$G$3,2,false) press enter.
  • The function will return the joining date for this L1056 employee code.

 
img2
 

  • Select the cell C9 and write the formula.
  • =LOOKUP(C8,$C$2:$G$3,2,false) press enter.
  • The function will return the joining date for this L1056 employee code.

 
img3
 
Note: If we do not have the common value in the data from which we want to pick the data so formula will give the #N/A error.

This is all about the Lookup function in Microsoft Excel 2010 and 2010.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube