Offset formula Error

[Excelawy]

Dear All,

the problem is when i put the below formula on offset function, the formula doesn't work

=OFFSET(RIGHT(TEXT(FORMULATEXT(AB19),""),(LEN(TEXT(FORMULATEXT(AB19),""))-2)),2,3)


the following formula that generate cell reference from Excel formula and it work perfect without Offset formula


=RIGHT(TEXT(FORMULATEXT(AB11),""),(LEN(TEXT(FORMULATEXT(AB11),""))-2))

the result is

Sheet4!BG37

 

[iliace]

What is in AB19 / AB11?

The fix might be as simple as:

=OFFSET(INDIRECT(RIGHT(TEXT(FORMULATEXT(AB19),""),(LEN(TEXT(FORMULATEXT(AB19),""))-2))),2,3)