"Sheeloo" wrote:

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

"Roy A." wrote:

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?

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.