I am getting muddled within my index find formulas.

I have the following formula which matches my lookup value to a particular header and returns the intersecting value:
=INDEX('[Workbook.xls]Jan'!A:CA,MATCH("Smith, John",'[Workbook.xls]Jan'!B:B,0),MATCH("Compliance Failures",'[Workbook.xls]Jan'!2:2,0))


However, one of these headers (Compliance Failures) appears 4 times in my indexed ranged.
Since I need to obtain the value in each of these 4 columns individually, how can i modify the above formula to look in the relevant column range each time?

headers.png

ps:
Unfortunately I am not able to amend the source workbook in any way.
I have chosen to use index/match as two versions of this document will be used and the columns I need to match to can move depending on the version - I found this the easiest way to ensure I it's as flexible as it can be without VBA. But I am open to suggestions...

Thanks all, again!