How to extract data from a data series?

Asked By Kelseyy Jones 0 points N/A Posted on - 08/21/2012

I have a spreadsheet including employee name and their salary details of all employees. I want to have a basic salary of selected employees in another excel sheet. Does anybody know an easy way to get that into the new excel sheet?

• Status: Open
• Question Views: 862
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Geisha Nitta 0 points N/A #145196

How to extract data from a data series?

Your requirement can be fulfilled using a function available in Microsoft excel. I will use ‘VLOOKUP’ function in this scenario. I will explain it through an example. Please see the image below.

In above picture demonstrate all the details of employees. On the other sheet there are selected employees that you want to take the basic salary.

Now in the new sheet type the following formula and open a bracket and click on the “fx’ button.

=Vlookup(

In the vlookup window click on the red arrow of the lookup value text box and select the cell D2.

Then click on the red arrow of the table array textbox and go to the first sheet and select all the data.

Now click on the Col_ Index_ num text box and type “2”.

Now type word “ false’ in the last text box( range lookup).

And click ok.

Now copy the same formula to below the cells. Then you can see the result you want.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 08/21/2012
• Question Category: MS Excel