Hello,
I have a formula in cell A1 like: ='UnCW'!B19 when UnCW is the name of an non active worksheet.

I want a formula in cell A2 to get the value of the offset (0,6) of 'UnCW'!B19

What would be the formula in A2?

Tried "INDIRECT" but probably, I am writing it incorrectly.


Thanks