Admittedly not great, but you can complete that join, output it as a table, and then apply formulas as desired if you use Power Query. Power Query solves many

Admittedly not great, but you can complete that join, output it as a table, and then apply formulas as desired if you use Power Query. Power Query solves many cases where a macro was previously required, but relatively few people are aware of it.