Example IF Problem.xlsx

For confidentiality reasons I can't attach my actual spreadsheet but I did quickly make up a similar one with the same IF statement I used to calculate the YTD revenue. Any potential help on making this formula easier to interpret would be greatly appreciated. I incorporated the lookup function you recommended for the monthly revenue and it works great so thanks for the help!