I have a budget related spreadsheet that calculates rates based on various criteria.
1. Either original budget or forecast budget
2. Either rehearsal rate or concert rate
3. Either regular pay rate or doubling pay rate
4. Either of two contract term time periods
I have the spreadsheet working except for the fact that I can not figure out how to have the entire formula determine if its one contract term vs. another. Currently, the example spreadsheet formula (built in the project tab) is only looking at the one row of contract term rates. But if you look in the project spreadsheet, you'll see that in column A, the row is based on one of two contract term time periods. The rate grid is also based on two contract term time periods but my formula isn't acknowledging both contract term periods at this point.
I started this whole formula with a vlookup on the contract term period and the rehearsal rate or concert rate fields. That all worked perfect. Then I realized that that method would not capture the fact that there are two types of pay rates - regular or doubling.
Is the rate grid even set up the right way? This can be redone if this would help resolve my issue.
I realize at this point that I have two horizontal matches and I'm trying to add in a vertical match....is that possible?
Thanks.
Bookmarks