Excel 2016 – 3.11.8 – AGGREGATE as a LOOKUP

Another great way to use this fabulous function, with a bit of mixed Absolute/Relative referencing thrown in.