...tweaking I finally got the offset working. I ended up nesting an offset within the offset to reference the correct cell. (=MAX(OFFSET(A58650,-1*(OFFSET($C$4,0,0)),0,OFFSET($C$4,0,0),1))
This probably isn't the most elegant way to express it, but it's working. Thanks for pointing me in the...