Need help with functionality more complex than VLOOKUP offers

[cswale]

First, I've attached an example of the *three* pages that I am trying t
get working.

The first page is the data, sorted by year then by product. This dat
is always in ascending yearly order. Page 2 and 3 are displays an
graphs of each individual product.

I want to setup Excel to automatically fill the tables on page 2 and
based on what data is in the columns in page 1. VLOOKUP has some of th
functionality to accomplish this. So, for example, the function woul
look up the product and bring back all associated rows and columns.

Is there any combination of functions that can perform this type o
behavior?
Thanks

+-------------------------------------------------------------------
|Filename: demo.jpg
|Download: http://www.excelforum.com/attachment.php?postid=4172
+-------------------------------------------------------------------

 

[sunnyland]

The answer is using Pivot Table,

Have a look at the enclosed file there is no macro just the use of
pivot table.
Francoise


+-------------------------------------------------------------------+
|Filename: UsingPivotTableandChart.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4275 |
+-------------------------------------------------------------------+