N/APosted 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?
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.
Now we will see how to apply the HLOOKUP function.
Type the following formula in cell B15 and click on the “fx’ button.
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.