call range by cell value

R

Roland

I have a worksheet that I want to call data from another sheet using offset
the formula works using named ranges but the range changes by what is input
by the user into certain cells. I used this formula to test it.

=OFFSET(Roland,0,4)*OFFSET(Roland,0,1)

Roland is the name of the range on a differenent worksheet. The value in
cell b3 in the worksheet is the name of the range I want to use.
 

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

Mapping integers to strings 5
Dependent drop down dynamic range formula, off sheet. 7
How do I have a cell value define a dynamic named range? 15
Drop Down with dynamic named range offsheet source list 14
named range in sum formula (indirect, offset, worksheet name) 4
Constructing Range Name calls with Concatenate 4
CountIf previous cell formula 0
Excel VBA 1

Top