Jun 29 2022 02:09 PM - edited Jun 29 2022 02:12 PM
Hi, I'm hoping to get some help figuring out how to inflate years 2023-2024 based on 2022 amount using account number as the identifier between two tabs. In addition, it'd be awesome if the formula only worked for "Ongoing" column if it's Y, (if it's N- $0). See below for the sample of the 'Expenditure Data' tab which is where the formula will got and 'Rates' table which is in a separate tab and I need to multiply the percentage by the amount in 2022 (1st table). The only exception where I'd add instead is for the account 5210. Thanks in advance to any excel guru/expert that can help with this!
Account | Amount | Ongoing | 2023 | 2024 |
5100 | 800,000 | Y | ||
5100 | 800,000 | Y | ||
5210 | 225,000 | Y | ||
5210 | 225,000 | Y |
Account | 2022 | 2023 |
5510 | 5.0% | 5.0% |
5520 | 4.0% | 3.0% |
5530 | 2.0% | 2.0% |
5310 | 4.0% | 4.0% |
5320 | 3.0% | 3.0% |
5100 | 2.50% | 2.50% |
5230 | 7.65% | 7.65% |
5210 | $ 15,000 | $ 16,200 |
Let's assume first account # starts on cell C3