Pulling data from a matrix/table

chart1.xls

There are going to be three different sets of matrices aside from the current "codename." I'm going to have users type in which set to pull data from, what tier it is, how many "moved," and finally by the days 30-240. I need some sort of formula to do this, because whatever I'm doing is going to take a very long time.

Basically if(type=codename, pull from table a, then look at tier, etc. etc. I can't find a way to do this without putting in a crazy amount of time. Suggestions would be great.

Originally Posted by tedium

chart1.xls

There are going to be three different sets of matrices aside from the current "codename." I'm going to have users type in which set to pull data from, what tier it is, how many "moved," and finally by the days 30-240. I need some sort of formula to do this, because whatever I'm doing is going to take a very long time.

Basically if(type=codename, pull from table a, then look at tier, etc. etc. I can't find a way to do this without putting in a crazy amount of time. Suggestions would be great.

The attached shows that you can use a Match to lookup the values across and down an Index Table. This should serve your purpose.

---