Calculated table/vlookup

I am struggling with the following: I have one table (1) with deal ID's and data about related activities (one deal ID can have multiple activity IDs). I have another table (2) with deal IDs and da...