Thank you both! I think I have enough to go on...

"Domenic" wrote:

> First, define a name for each of your tables. For this example, we'll
> name the first table CustomerA, the second table, CustomerB, etc. But
> don't include the column and row headers in the reference. So, for
> example, if Sheet2!A1:D5 contains your first table...
>
> Insert > Name > Define
>
> Name: CustomerA
>
> Refers to: =Sheet2!$B$2:$D$5
>
> Click Add, and continue with the remaining tables. Notice the column
> and row headers are not included.
>
> Secondly, set up a table with the column and row headings only, let's
> say B4:E8, something like this...
>
> Product Classes..........2005.....2006.....2007
> Premium Products
> Economy Products
> Seconds
> Imports
>
> Then, select C5:E8 (these cells should be highlighted) and enter the
> following formula...
>
> =INDEX(INDIRECT(B2),0,0)
>
> ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER, and where B2
> contains the customer name, such as CustomerA.
>
> Hope this helps!
>
> In article <ED7B212F-F633-48C5-B8CC-44EF344B4052@microsoft.com>,
> "KG" <KG@discussions.microsoft.com> wrote:
>
> > I have never used multiple tables, so I am hoping that you can steer me in
> > the right direction:
> >
> > I have a list of five possible Customer names & four product classes that
> > apply to all of them:
> > Premium Products
> > Economy Products
> > Seconds
> > Imports
> >
> > Then there would be be five lookup tables with commission rates; Table1 will
> > apply to Customer A, Table2 to Customer B etc. All five commission tables
> > would be of the same design:
> >
> > Premium Products, Economy Products, Seconds and Imports will be the row
> > labels. The column headings would read 2005, 2006, 2007, etc. and in the
> > intersects there will be commission rates in percent.
> >
> > So, now I want to populate a table with commission payments by product and
> > by year, depending on the customer name to be entered in cell B2. If the
> > Customer name is "A", I would want want to go to Table1, if Customer "B" to
> > Table2, etc.
> >
> > I presume that this would require the use of MATCH and VLOOKUP, but I am not
> > sure if there are other steps
>