Hi, hope this is in the right place.
I am trying to produce a spreadsheet that will estimate amounts of redundancy compensation based on salary, age and continuity of service. I have had no problems generating usable results from salary, hours, date of birth, date of commencement and termination date for these variables. I now want to use the generated age and continuity of service integers to reference the matrix on the ‘table’ sheet and to automatically insert the result into the ‘redundancy weeks’ cell. This is for multiplying the weekly wage to find the estimated amount e.g. Continuity 20 (Column J) and Age 30 (Row 14) cross at 20 (J14). This is the number that needs inserting in the redundancy weeks cell.
Unfortunately I have no idea how to do this and I have Googled etc and emerged none the wiser.
Please help.
Bookmarks