How can i add to a cell address? My existing formula isn't working.

		Microsoft Office Forums > Microsoft Excel > Excel
How can i add to a cell address? My existing formula isn't working.

02-02-2019, 01:42 AM

xor

Windows 10 How can i add to a cell address? My existing formula isn't working.

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

If I understand you correctly, put in E2

=INDIRECT("r["&+C2&"]c1",0)

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
Word 2016, autoformating existing text not always working	tammons	Word	7	08-23-2016 12:47 AM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM
Changing Cell address within a formula	vermont_past	Excel	12	09-21-2012 12:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:31 AM.