Try this:

A10 = 11

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=INDEX(A1:M1,MATCH(1,(MOD(COLUMN(A4:M4),4)=1)*(A4: M4A10),0))

Biff

"SJT" wrote in message
...
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.