VLOOKUP or INDEX/MATCH?

Hello,

I have a look up table that I would like to populate with where a client was in the pipeline on a particular date. I would like to do a VLOOKUP on my activity table, but only look for entries prior to a given date. Does anyone have any suggestions? I have attached a sample file.

Thank you!