Help with Formula Vlookup, collect, if?
Not sure if this is possible but I have a sheet to track monthly billing and another sheet to forecast milestone completions.
On the monthly billing sheets I want it to look at the milestone forecasting sheet and if a milestone is forecasted to complete in a month add a billings to the billing sheet.
Billing sheet looks like this:
For Test customer in each monthly Column I want it to look at the milestone sheet and if the project has a milestone dated for the referenced month pull in the correct billing.
This is the Milestone sheet for the customer:
This customer closes phase 3 in may 2023 so in the billing sheet I want to see nothing for Jan - april but in the May column it should pull in $11,512.50, and then in July $9210 so on and so forth and I have no idea where to even start
Help Article Resources
Check out the Formula Handbook template!