There will not be an exact (date match) in the exchange view. This is updated once per week.

What I was thinking about doing is adding a week and year number column to the source and the lookup view so I could match on that?

What confuses me the most is the logic for the lookup and how it works.

Any good starting points? (Besides dragging it on the canvas):-)