Referencing a range name as part of a formula\

R

Ron Pollock

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Vlookup and return sheet name also 2
VBA for Dependents shortcut menu 0
Multiple Criteria, One Answer 1
Problem using IF statement with dates as part of the formula 4
Problem with SET & REF function 0
Median Formula not working properly 2
Pasting a cell into bookmarked table from excel vba 1

Top