I attached a solution making full use of the capacities of INDEX.
For it to work, column headers must be the same
(Hope it's OK for the MAC version)

Attached Files

Xl0000403_gen.xls (303.0 KB, 9 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post