I am trying to figure out how to look up a # from a table and insert it into a spreadsheet. Not sure how to do, maybe someone could help. See the following example:
On sheet one I have the following:
Eff Age____NUL_____Dep %
10________ 15____what i need
2 _________14____what i need
16________ 15____what i need
On sheet two I have the table that has the Eff Age in Column A, the NUL in Row 2, and the Dep % inside the table, kind of like this.
Eff Age____15___14___13 (NUL)
1__________5___ 5____6
2__________10__11___12
3__________15__16___18
4__________21__23___25
and so on
So for example row 3 on sheet 1 (2, 14, what i need), would ultimately coorespond to row 3, column 3 (11) on sheet 2.
Is there a formula I can use to have this calculated based on columns 1 and 2 on sheet 1.
Any help would be greatly appreciated. Thanks!
On sheet one I have the following:
Eff Age____NUL_____Dep %
10________ 15____what i need
2 _________14____what i need
16________ 15____what i need
On sheet two I have the table that has the Eff Age in Column A, the NUL in Row 2, and the Dep % inside the table, kind of like this.
Eff Age____15___14___13 (NUL)
1__________5___ 5____6
2__________10__11___12
3__________15__16___18
4__________21__23___25
and so on
So for example row 3 on sheet 1 (2, 14, what i need), would ultimately coorespond to row 3, column 3 (11) on sheet 2.
Is there a formula I can use to have this calculated based on columns 1 and 2 on sheet 1.
Any help would be greatly appreciated. Thanks!