How to extract selected data in Microsoft excel?

Asked By Kylie Caseey 30 points N/A Posted on - 08/21/2012

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

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 Geisha Nitta 0 points N/A #145369

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.

Now we will see how to apply the HLOOKUP function.

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

=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.)

Then type the 4 in the Row_ Index_ Num.

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

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

Questions
1

Answers
55

Best Answers
27

Third party software getting error