software

address comand returns value of a single cell, by giving the cekk address as
text input.
Is it possible to return a range of cells, instead of one vell either by
address or any other command?
In the following formula:
VLOOKUP($A1239;[runs_input.xls]run1!$G$4:$G$145;1;0)
I want to give [runs_input.xls]run1!$G$4:$G$145 range,
as an input so that I can copy run1 easily from run1 to run50.
--
Rasoul Khoshravan Azar
Civil Engineer
Osaka, Japan

As long as Runs_Input.xls is going to be open, you could use =indirect().

=VLOOKUP($A1239;indirect(quot;[runs_input.xls]runquot;amp;row(a1)amp;quot;!$G$4:$G$145quot;;1;0)
and drag down.

But this will break as soon as runs_input.xls is closed (and excel
recalculates).

If this is a one time thing, you can build a formula that helps build the
formula:

=quot;$$$$$=vlookup($A1239;[runs_input.xls]runquot; amp; row(a1) amp; quot;!$G$4:$G$145;1;0)quot;
drag down the column.

Now select that range and
edit|copy
edit|paste special|values

Now with that range still selected
edit|replace
what: $$$$$=
with: =
replace all

Do a test on a short list (run1, run2, run3). If you make a mistake in your
formula, you may end up dismissing 50 dialog boxes trying to find the correct
file.Khoshravan wrote:
gt;
gt; address comand returns value of a single cell, by giving the cekk address as
gt; text input.
gt; Is it possible to return a range of cells, instead of one vell either by
gt; address or any other command?
gt; In the following formula:
gt; VLOOKUP($A1239;[runs_input.xls]run1!$G$4:$G$145;1;0)
gt; I want to give [runs_input.xls]run1!$G$4:$G$145 range,
gt; as an input so that I can copy run1 easily from run1 to run50.
gt; --
gt; Rasoul Khoshravan Azar
gt; Civil Engineer
gt; Osaka, Japan

--

Dave Peterson