Offset from cell referenced in a formula

[Bengo]

Evening,

I am trying to figure out how to offset based on a cell referenced in a formula

So for example if Cell B5 had the formula: "=B20", I would want in another cell, say cell A1 to look at B5, and return the cell one column to the right, e.g B21

Hope this makes sense!

Thanks in advance,
Ben

 

[Bengo]

Gents that has worked a treat! Came in this morning and the job was done within minutes!! thank you very much for your support! Saved me a good couple of hours today!

Thanks,
Ben