How to extract data from a data series?

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #145196

How to extract data from a data series?

qa-featured

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.

Vlookup Function

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.

Excel sheet

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

=Vlookup(

Using vLookup

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

Vlookup for selected row

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

table array textbox

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

Vlookup in Excel

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.

Formula in Office

Related Questions