software

I want to enter cell addresses and range addresses in formulas (functions)
such as vlookup using row and column numbers that are calculated elsewhere on
the spreadsheet. How do I write the range formula in a manner that takes its
cell address parameters from those other cells?
Precede the cell address with INDIRECT, such as INDIRECT(A1) will result in
the formula evaluating to say G15, if A1 contains text quot;G15quot;

quot;TimRTiquot; wrote:

gt; I want to enter cell addresses and range addresses in formulas (functions)
gt; such as vlookup using row and column numbers that are calculated elsewhere on
gt; the spreadsheet. How do I write the range formula in a manner that takes its
gt; cell address parameters from those other cells?
gt;
gt;

Try INDIRECT

HTH
--
AP

quot;TimRTiquot; gt; a écrit dans le message de
...
gt; I want to enter cell addresses and range addresses in formulas (functions)
gt; such as vlookup using row and column numbers that are calculated elsewhere
on
gt; the spreadsheet. How do I write the range formula in a manner that takes
its
gt; cell address parameters from those other cells?
gt;
gt;
=VLOOKUP(...,INDEX(Range,X2,Y2),...)

TimRTi wrote:
gt; I want to enter cell addresses and range addresses in formulas (functions)
gt; such as vlookup using row and column numbers that are calculated elsewhere on
gt; the spreadsheet. How do I write the range formula in a manner that takes its
gt; cell address parameters from those other cells?
gt;
gt;

Kassie,
This looks to be the Rosetta Stone for me. Thanks. I still need to do some
experimenting with it, but a quick check says it works.

quot;kassiequot; wrote:

gt; Precede the cell address with INDIRECT, such as INDIRECT(A1) will result in
gt; the formula evaluating to say G15, if A1 contains text quot;G15quot;
gt;
gt; quot;TimRTiquot; wrote:
gt;
gt; gt; I want to enter cell addresses and range addresses in formulas (functions)
gt; gt; such as vlookup using row and column numbers that are calculated elsewhere on
gt; gt; the spreadsheet. How do I write the range formula in a manner that takes its
gt; gt; cell address parameters from those other cells?
gt; gt;
gt; gt;

If you can avoid indirect by for instance using index (index can use other
cells as row and column numbers) than you should do that. indirect is a
volatile function so it slows down a workbook since they recalculate where
others don't

www.decisionmodels.com/calcsecretsi.htm

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;TimRTiquot; gt; wrote in message
...
gt; Kassie,
gt; This looks to be the Rosetta Stone for me. Thanks. I still need to do
gt; some
gt; experimenting with it, but a quick check says it works.
gt;
gt; quot;kassiequot; wrote:
gt;
gt;gt; Precede the cell address with INDIRECT, such as INDIRECT(A1) will result
gt;gt; in
gt;gt; the formula evaluating to say G15, if A1 contains text quot;G15quot;
gt;gt;
gt;gt; quot;TimRTiquot; wrote:
gt;gt;
gt;gt; gt; I want to enter cell addresses and range addresses in formulas
gt;gt; gt; (functions)
gt;gt; gt; such as vlookup using row and column numbers that are calculated
gt;gt; gt; elsewhere on
gt;gt; gt; the spreadsheet. How do I write the range formula in a manner that
gt;gt; gt; takes its
gt;gt; gt; cell address parameters from those other cells?
gt;gt; gt;
gt;gt; gt;