D
dizzynumber
creating an employee salary table. Several pieces of data to consider: the
step (number of years) and the level of education to date. The step is
listed vertically and the degree(s) are listed horizontally. How can I enter
a formula to find the intersection of the two?
Last_Name First_Name Salary_Column Old Step New Step Salary
Jones Sam BA+20 15 16 should be 36,541
Table of Data:
Years BA BA+10 BA+20 BA+30 MA MA+10 MA+20
16 35,136 35,839 36,541 37,244 38,123 39,001 39,879
step (number of years) and the level of education to date. The step is
listed vertically and the degree(s) are listed horizontally. How can I enter
a formula to find the intersection of the two?
Last_Name First_Name Salary_Column Old Step New Step Salary
Jones Sam BA+20 15 16 should be 36,541
Table of Data:
Years BA BA+10 BA+20 BA+30 MA MA+10 MA+20
16 35,136 35,839 36,541 37,244 38,123 39,001 39,879