Cell Location Reference

[Roy A.]

I have a cell R2 which shows "C7" as its value. I would like to reference R2
in a formula and obtain the value in cell C7. Is this possible?

 

[Sheeloo]

Use in any cell other than C7 or R2
=Indirect(R2)

 

[Roy A.]

Use in any cell other than C7 or R2
=Indirect(R2)

Thank you Sheeloo this worked perfectly and is a much easier answer than
using multiple if statements on the worksheet. Thank you very, very much.