Quote Originally Posted by gnoke View Post
Thanks for answering!

The formula works well for the sample sheet, but not with my original (much larger) dataset. It is not always the month and date values are available in both sheets. Therefor I try to search for the closest before date and not an exact match.
Any ideas?

Thanks again

Gnoke
Oh, I concluded that there were always dates for the 1st of each month, so I transformed the lookup dates.