Referencing a range name as part of a formula\

Referencing a range name as part of a formula\

Post by Ron Polloc » Fri, 27 Jun 2003 10:40:51


I am attempting to import data from another worksheet based on selectable
criteria.

For example, if I have 3 worksheets A, B, & C with a range name of RangeB
for the sheet B data and RangeC for the sheet C data. On Sheet A, a
specific cell say A1 will contain either A or B which would identify the
range name. I want to reference cell A1 as part of the formula to bring in
data from the other sheets.

The formula would be something like if Cell A1=Range A :

='A1'!$B$1 where A1 should reference RangeA and bring in the contents of
sheetA!A1.

Any help would be greatly appreciated.
--
Ron