I was wondering if someone can please help. I have a spreadsheet (please see attached), where I need a formula which lookups the date and returns a value based on a date in specific cells. I have tried to explain this clearly in the attached spreadsheet and I will appreciate if someone can please help. I think this is easily achievable but cannot think of a formula.
Can someone please help.