Forum Discussion

Copper Contributor

May 03, 2020

Solved

Variable cell formula

Is there a way to change the cell on a formula with a variable from another cell. Ex. Getting the result of cell K11 if I have a value 11 on cell D1 and have it changed to get the result of K23 if ...

excel

Formulas and Functions

wumolad
May 03, 2020
Hi miguel_g_s

You can use this for the value in cell K11:

=INDIRECT(ADDRESS(D1,11))

Cheers

Emmanuel

wumolad

Iron Contributor

May 03, 2020

Hi miguel_g_s

You can use address function

=ADDRESS(D1,11)

Cheers,

Emmanuel

miguel_g_s
Copper Contributor
May 03, 2020
That gives me as a result K$11$ but not the value on cell K11,
Thank you
wumolad
- wumolad
  Iron Contributor
  May 03, 2020
  Hi miguel_g_s
  
  You can use this for the value in cell K11:
  
  =INDIRECT(ADDRESS(D1,11))
  
  Cheers
  
  Emmanuel
  - miguel_g_s
    Copper Contributor
    May 03, 2020
    Thank you very much!
    Is there any chance you also knew how to include that in a range, say for example =SUM(INDIRECT(ADRESS(D1,11)):K200)
    wumolad