VLOOKUP Function in Excel 2010

In this article I am going to explain about Vlookup function in Excel 2010.
  • 2967

VLOOKUP Function in Excel 2010

Vlookup function use to search the value in left must column in table array and return the value on specified index number.

To use Vlookup Function we have to follow following steps.

Step 1

Open worksheet and select cell where we want to get vlookup result.

look1.jpg

Step 2

In Formula tab click on Insert Function.

look2.jpg

Step 3

Than a Insert Function dialog box will be open. In this dialog box we select Vlookup function and click OK.

look3.jpg

Step 4

After its a  new Function Arguments dialog box will open.

look4.jpg

Step 5

In Lookup_value we enter lookup value. (such as Arjun in my example)

In Table Array we enter the range of cell.

In Col_index_no we enter the index number. (such as 4 it is the index no of phone no column).

And click OK.

look5.jpg

Step 6

Result will be display.

look6.jpg

Ask Your Question 
 
Got a programming related question? You may want to post your question here
 

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.