cell value

L

Learn Excel

This is what I am trying to do. I am trying to give reference of a cell by
adding number to that cell.
Means I am trying say cell D5= C12. But I would like to set up a formula
stating C(5+7)

Any help appreciated.

Thanks
 
B

Bernard Liengme

Have a look in Help for the INDIRECT function
Let G1 have the value 5 and G2 the value 7, then the formula
=INDIRECT("C"&G1+G2) will be equivalent to =C12
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Losing Data From Formulas When Cell Variable Changes 6
Hide columns based on row values 2
Drop down list control value in vba 2
Excel Countif Function - Calculating Between Two Sets of Values 3
Extracting data/using COUNTIFS 2
Multiple IF statements, macro stops at first True 0

Top