address command for a range of cells, not one cell

Giganews Newsgroups
Subject: address command for a range of cells, not one cell
Posted by:  Khoshravan
Date: Thu, 4 May 2006

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

Replies