call range by cell value

  • Thread starter Thread starter Roland
  • Start date Start date
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.
 
Back
Top