IF and LOOKUP for multiple values

Hi, I have two tables, spend table and contract table similar to the below normalised data   I have linked the two tables by Vendor ID and have a dim-date (calendar) table. This may be two issues...