Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |