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