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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 09:59 AM.