How to use an index number in a search range
 

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)

How to use an index number in a search range
 

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)

How to use an index number in a search range
 

Nick,
I cannot fully understand what you are looking for, but it seems to me
you need the OFFSET()function. Use the expression as the 3rd argument.
If your problem went down columns instead of across rows you could have
also used INDIRECT().

HTH
Kostis Vezerides