Sumif/match/vlookup/other

New Contributor

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!

 

AccountAmountOngoing20232024
5100               800,000Y  
5100               800,000Y  
5210               225,000Y  
5210               225,000Y  

 

Account20222023
55105.0%5.0%
55204.0%3.0%
55302.0%2.0%
53104.0%4.0%
53203.0%3.0%
51002.50%2.50%
52307.65%7.65%
5210 $  15,000 $  16,200

Let's assume first account # starts on cell C3

0 Replies