hlookup and offset

[dmj120]

I'm trying to combine hlookup() and offset() to find the last value in a row, then go up 2 rows and left 1 cell. Each works independently, but when I try to combine them, errors occur.

=OFFSET(M3,-2,-1) --- "M3" is the below hlookup() reference
=HLOOKUP(9.99999999999999E+307,B3:Y3,1)

Is there a way to accomplish this?

 

[Peter_SSs]

Thanks Peter! That works perfectly! Thanks for the volatile link as well, I'm saving that

You are very welcome.