I know how to use the indirect formula in a sheet itself.

```
=INDIRECT(CHAR(ROW(A5))&ROW(A5))
```

However, I am having hard time manipulating this to find a formula from different sheet called 'sheet1'

I am trying to retrieve value in B3 of Sheet1 using indirect formula. Any help is appreciated.

Please note, going forward (I plan to drag this formula down) I plan to manipulate rows and columns so I do want both of them (rows and columns) as variable values.

Eg: NOT indirect('Sheet1'!B3) but rather something like indirect('Sheet1!'&char(row(a5))...etc) which is not working for me.

Thanks for the help!

`='Sheet1'!$A3`

this would keep the column static while the rows change when dragged. As I read your formula it does the same thing.