OFFSET Range

G

Guest

I have the following string in cell A1:
SIM5$A$1


I would like to use it as a range for offset and does not work, I suppose
because it is a string and not a range.
Question: how do I make it into a range to be able to use offset
thanks
 
B

Bob Phillips

Is SIM5 a worksheet?

If so, maybe

=INDIRECT("'"&LEFT(A1,FIND("$",A1)-1)&"'!"&MID(A1,FIND("$",A1),99))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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

Event recognition. 6
Mapping integers to strings 5
Dependent drop down dynamic range formula, off sheet. 7
Complex date VBA - insert a certain weekday 5
Drop Down with dynamic named range offsheet source list 14
Dynamic Range for Offset 8
XL2007: I need a sumproduct formula that will transpose as I copyacross columns 2
reference to other sheet as a string 1

Top