Hi,
I am stuck on a formula and after some help please.
I am after a table lookup based on 2 criteria, one being a date range (this is where I am having problems). Example is attached. I want column D to complete using the lookup table. The criteria is for column B to match column J and column C to be within the date range in K and L, giving the result from column M. So the result in cell D4 should be 2019. Exactly the same principle for column E.
Capture.PNG
How do I do this?
Thanks.
Bookmarks