I am having a little bit of a problem trying to figure out how to come up with a formula for my spreadsheet. Let me explain what I am trying to do.
I am using a spreadsheet to show the pay class of employees.
On Sheet1 , I have three columns: Employee, Pay Class, and Pay Schedule. Based upon the Pay Class, the employee will receive their Check every week (Class A), every two weeks (Class B), or every month (Class C). A user would enter the employee name and pay class, then the pay schedule would automatically be "looked up" from a table I have in Sheet2.
I am trying to set up the spreadsheet in this manner so that if the pay schedule were to change, so from 1 week for Class A to Every two weeks, I would not have to go into the spreadsheet and change the pay class on the Sheet 1 for every employee.
On Sheet 2, I have two Columns: Pay Class, Pay Schedule. Currently there are 3 pay classes, but in the future, I need the ability to add more if needed.
Information would be entered in in this manner:
Sheet 1
Sheet 2
I have never done anything like this in the past, so I am having some problems with it. I thought about trying to hard code it into a formula using IIF's, but this would not give me the flexibility that I am looking for.
Any help would be greatly appreciated! Thank you in advance!
I am using a spreadsheet to show the pay class of employees.
On Sheet1 , I have three columns: Employee, Pay Class, and Pay Schedule. Based upon the Pay Class, the employee will receive their Check every week (Class A), every two weeks (Class B), or every month (Class C). A user would enter the employee name and pay class, then the pay schedule would automatically be "looked up" from a table I have in Sheet2.
I am trying to set up the spreadsheet in this manner so that if the pay schedule were to change, so from 1 week for Class A to Every two weeks, I would not have to go into the spreadsheet and change the pay class on the Sheet 1 for every employee.
On Sheet 2, I have two Columns: Pay Class, Pay Schedule. Currently there are 3 pay classes, but in the future, I need the ability to add more if needed.
Information would be entered in in this manner:
Sheet 1
Code:
[U]Employee | Pay Class | Pay Schedule[/U]
Bob | A | Weekly (*comes from Sheet 2)
Brenda | B | Bi-Weekly (*comes from Sheet2)Sheet 2
Code:
[U]Pay Class | Pay Schedule[/U]
A | Weekly
B | Bi-Weekly
C | MonthlyI have never done anything like this in the past, so I am having some problems with it. I thought about trying to hard code it into a formula using IIF's, but this would not give me the flexibility that I am looking for.
Any help would be greatly appreciated! Thank you in advance!
