Results 1 to 4 of 4

Using data contained in a matrix table on another sheet

Threaded View

redimp Using data contained in a... 08-18-2010, 12:11 PM
JBeaucaire Re: Using data contained in a... 08-18-2010, 12:45 PM
redimp Re: Using data contained in a... 08-18-2010, 01:16 PM
JBeaucaire Re: Using data contained in a... 08-18-2010, 01:50 PM
  1. #1
    Registered User
    Join Date
    08-18-2010
    Location
    Lincoln, UK
    MS-Off Ver
    Professional Plus 2010
    Posts
    37

    Using data contained in a matrix table on another sheet

    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.
    Attached Files Attached Files
    Last edited by redimp; 08-18-2010 at 02:44 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1