Shift a referenced cell in another Worksheet 3 columns.

[Lambrix]

Greetings,

This might be a simple noob question but I cant seem to wrap my head around it. In column I3, I reference data on another worksheet. I want the formula format to shift to the right 3 columns each time.

Here is the original info: I3='0152'!O3, I want to create a formula that will reference 3 columns to the right of the data linked in I3. So '0152'!R3 in this example. Is there an easy way to accomplish this?

 

[Juglaz]

If I'm understanding your question correctly...

Function indref(r As Range) As String
indref = Range(Right(r.Formula, 2)).Offset(0, 3).Value
End Function

 

[Juglaz]

Correction...

Function indref(r As Range) As String
indref = Range(Mid(r.Formula, 2)).Offset(0, 3).Value
End Function