How to use CELL function inside OFFSET function?

I am trying below formula:

OFFSET(CELL("address"), 0, -2, 1, 1)

Instead this works:

OFFSET($P$20开发者_如何学JAVA, 0, -2, 1, 1)

I do not have the cell reference and so have to compute in formula itself. How to do it?

Thanks in advance!

Niraj

If you want to replace $P$20 by a string you compute, use

.... INDIRECT(function) ....

where function returns an A1-style or R1C1-style address (in the latter case you specify a second arg FALSE