Hi guys,
I am struggling with a INDEX,MATCH and MAX formula. I am trying to retrive values from column E with two criterias:
1. That the value in column C is equal to a lookup value
2. That the date in column A is the closest before date for a lookup date
I have attatched an example file that hopefully will explain better.
I would really appreciate all help
Gnoke
Bookmarks