Cannot find a header when value repeats in a column

Hello everyone,

I need to find headers from different sheets in column M:M. I came up with the formula but it fails when it discovers several repeating values in the same column.

What is missing that formula would return to a header even if the values are repeating in the column?

Any suggestion how to solve this is appreciated :)