Hi all,
Please could someone help with a formula that would Lookup a value then looks down a table to find it then across (dynamic rows). The rows will retract and expand depending on the date/day of the month.
For ease I have attached a sample worksheet with some representative sample data and some manually calculated results. The worksheet is GDPR checked and there is no sensitive data on there.
Thank you for your help and as always very much appreciated.
Mark
Bookmarks