How to extract selected data in Microsoft excel?

Asked By 30 points N/A Posted on -

I have an excel sheet including sales of each item in each day. Please see the image below.

Excel Sheet

This is for an example. There are about 100 items.

I want to extract sales of selected items in a particular date. Is there any easy way?

Answered By 0 points N/A #145369

How to extract selected data in Microsoft excel?


Yes there is an easy way to extract selected data in Microsoft excel. We can use “HLOOKUP’ function in this regards.

I will take the same example. I will select some items and a date which is going to extract from the table.

Item Sales Each day

Now we will see how to apply the HLOOKUP function.

Type the following formula in cell B15 and click on the “fx’ button.


Function Agreement HLOOKUP

Click on the red arrow which is in a lookup value text box and click on the B14 (Item).

Then click on the red arrow in the table array text box and select the previous table. (Item names and values only.)

Hlookup funtion

Then type the 4 in the Row_ Index_ Num.

Excell HLOOKUP function

Finally, type the “false” in the Range lookup.

Excel function HLOOKUP

Now copy the same formula in to front cells. You will be able to get the result you want as follows.

Hlookup Functions

Login/Register to Answer

Related Questions