If you use an array in a non-array function, it just returns the first
value. If you use it in an array function, such as MIN, the whole array is
returned (and processed by that function). That's the way it works.
--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jim Russell" wrote in message
...


"Bob Phillips" wrote:

=MIN(INDEX(colL,ROW()),INDEX(colM,ROW()))

...
Thanks. That does indeed work, but it does do some violence to the
readability of the formula. Interesting that "colM" (the range name by
itself) returns the single value for the same row as the formula, but
putting
it in a MIN function does not work (e.g. MIN(colM,colL) -- that returns
the
min value of all cells in the named ranges.