| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Keeping variables in a formula
I'm copying a formula to 100 different cells, and I want every cell to maintain a reference to an array, but in another area of the formula, I want it to update with the corresponding row that it's on. Is there a way to do this? This is an example of the formula: INDEX(Sheet1!A1:G20, MATCH(LEFT(A1, 4), Sheet1!A1:A20,0),20) I want "Sheet1!A1:G20" and "Sheet1!A1:A20" to stay the same, but I want A1 to change to A2, A3, A4 and so on.... Any Suggestions? Thanks Brian -- Brian Mann ------------------------------------------------------------------------ Brian Mann's Profile: http://www.excelforum.com/member.php...o&userid=27466 View this thread: http://www.excelforum.com/showthread...hreadid=470033 |
|
#2
|
|||
|
|||
|
I did it again... so sorry... I found the answer... I promise I won't cry wolf again!! :) -- Brian Mann ------------------------------------------------------------------------ Brian Mann's Profile: http://www.excelforum.com/member.php...o&userid=27466 View this thread: http://www.excelforum.com/showthread...hreadid=470033 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vary variables in a formula via reference to another cell | Excel Discussion (Misc queries) | |||
| Removing formulas but keeping formula totals. | Excel Discussion (Misc queries) | |||
| Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| How to use array formula for three variables? | Excel Discussion (Misc queries) | |||
Linear Mode
