help with formula=)

[sidel80]

Hi all,

Just a quick question. Is there a function that will allow me to do this:

Example:

10 20 30 40 50

MktA 1 3 6 2 5
MktB 3 8 1 4 7
MktC 4 7 8 9 0


It will link to another spreadsheet which will basically look at Market A and also look at the top row (I.E. 10, 20, 30, 40, 50) and pull from the right columns. That would mean I would have to specify that in Market A, Tier 1, I am looking at only the numbers in the 10’s, 40’s, and 50’s column.

Tier 1 Tier 2
A
B
C
D

Sure, I can just link them, but if the columns change, it would screw up my data. Any function intuitive enough to look at the column heading and column row? Thanks in advance.!