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

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

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

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


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

--
cswale
------------------------------------------------------------------------
cswale's Profile: http://www.excelforum.com/member.php...o&userid=29991
View this thread: http://www.excelforum.com/showthread...hreadid=497271