I have an extensive spreadsheet that contains tables of data for account
names by year. I would like to have a cell return data from the tables when
the account name and applicable year are typed into a worksheet. For
example, in workbook 1, separate 4 x 3 tables are set up for Accounts "A"
thru ""G", for years "1994" -"2004" (77 tables in all--7 accounts/11 years).
In workbook 2, when the user types in "A" in A1 and "2004" in A2, I would
like A3 to show the applicable table. If I have to reproduce the table cell
by cell that's OK. I just need help with reproducing the cell results from
the applicable table when the appropriate account/year are entered. I can't
nest IF's because I have too many conditions to test for.

Any ideas?