|
|
#2
02-02-2019, 01:10 AM
|
||||
|
||||
Hi and welcome
why not in one go, something like =INDEX(A:A,MATCH(A2,A:A)+C2,0) Eventually post a sample sheet with some data and expected results
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
| Tags |
| excel 2013 formula |
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode