Please Help: Adding an equation to a range

Is it possible to add an equation to a range of data? For example, I am using the MATCH function to return the row number of a last value in a specific column.

=MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)

I would like to use this row number to establish a named range that will adjust as a given set of data changes. For example, if the formula returned 100, I need the named range to be A1 to K100.

Any different methods or suggestions?

Let's say you want to sum A1:K100 and the cell that returns 100 is L2, you can try:

SUM(A1:INDIRECT("K"&L2))

Hope it helps.

Originally Posted by tobriant

Is it possible to add an equation to a range of data? For example, I am using the MATCH function to return the row number of a last value in a specific column.

=MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)

I would like to use this row number to establish a named range that will adjust as a given set of data changes. For example, if the formula returned 100, I need the named range to be A1 to K100.

Any different methods or suggestions?

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>

Check out Debra Dalgleish's web page on this subject:

http://www.contextures.com/xlNames01.html#Dynamic

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tobriant" <tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com> wrote in
message news:tobriant.1ubxuk_1124989567.2993@excelforum-nospam.com...
>
> Is it possible to add an equation to a range of data? For example, I am
> using the MATCH function to return the row number of a last value in a
> specific column.
>
> =MATCH(LOOKUP(9.9999999999E+100,'Data'!E:E),'Data'!E:E,0)
>
> I would like to use this row number to establish a named range that
> will adjust as a given set of data changes. For example, if the formula
> returned 100, I need the named range to be A1 to K100.
>
> Any different methods or suggestions?
>
>
> --
> tobriant
> ------------------------------------------------------------------------
> tobriant's Profile:
http://www.excelforum.com/member.php...o&userid=25155
> View this thread: http://www.excelforum.com/showthread...hreadid=399140
>