I am attempting to create a formula that I believe needs to utilize the Match
function. I would like to look at the values in certain cells (every 4th
column in a given row) and see if they exceed a certain value and for the
first one that does, I would like the result to be what appears in the same
column but in a row above.

For example, If I had the values 5, 7, 10, 15 in cells A4, E4, I4, and M4
the formula would look for the first instance of a value above 11 (in this
case cell M4) and the result would be the conents of cell M1. How would I
accomplish this. Thank you in advance for your assistance.