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

--
HTH

Bob

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

"Jim Russell" wrote in message
...
I have a formula that includes the expression "min(L2,M2)". I want to be
able
to name columns L and M, and have those names used in the expression. The
row
number is relative, so the formulas below are "min(l3,M3)", etc. (The
formula
should be min($L2,$M2) to keep the column references absolute, but that
change does not seem to help my problem.)
How should I name the columns to be able to apply them, and what should
the
formula look like when it is done? (I would guess the name would
reference,
e.g. $M$M, but what then? The rows do not have names.)
Thanks!