Nick,

With that formula in cell A1:

=MAX(INDIRECT(ADDRESS(22,A1+2)&":K22"))

You need to add 2 to account for the offset from column A of your search range.

HTH,
Bernie
MS Excel MVP


"Nick Krill" wrote in message
...
The following returns the relative position of an entry in a row of unsorted
data:
{=MATCH(TRUE,D!C22:BD22<C22,0)}

How can I use the value returned by the above for the beginning position in
a search range in row# 22

similar to:
=max(the value created by the above formula:k22)