Index Match row value and nth occurrence of header

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!

=SMALL(IF('[Workbook.xls]Jan'!2:2="Compliance Failures",COLUMN('[Workbook.xls]Jan'!2:2)),1)
Will return the column number of the first occurrence of the header "Compliance Failures".

=SMALL(IF('[Workbook.xls]Jan'!2:2="Compliance Failures",COLUMN('[Workbook.xls]Jan'!2:2)),2)
Will return the column number of the second occurrence of the header "Compliance Failures" and so on.

You will need to enter them as array formulae i.e. press CTRL + SHIFT + ENTER rather than just ENTER as you would with an ordinary formula.

You should be able to use this within your index formula but as I'm not sure of exactly how your spreadsheets work I won't attempt to write the whole formula for you.

Perhaps someone else can help you there...

Hope this helps, good luck.