Changing the values in text

[tonypg]

Hi I have the formula to obtain a Cell value

Please Login or Register  to view this content.

This will return the value something like: $Q$23

I want to then change the body of text $Q$23 to the next increment, which would be $R$24

Can anyone assist with this?

Many thanks
Tony G

[Pete_UK]

You could add +1 immediately after the close bracket of the MATCH function.

Hope this helps.

Pete

[tonypg]

Hi Pete,

Thanks that helps a little as it increments the numerical value but not the text.

The result is $Q$24

[tonypg]

I made a workaround by using this formula.

Please Login or Register  to view this content.

Now I need to use this value $R$24 as a cell location and not as text. i.e.

Sum(A1:$R$30)
Where A1 contains the value $R$24

[tonypg]

Tried this but it didnt work:

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Trythis

Please Login or Register  to view this content.

OFFSET is a volatile function If table is very large it may slow down excel.

[tonypg]

Thanks for the answer but I worked it out and used this formula.

=SUM(INDIRECT('Plan Data'!$I$14):R29)