Keeping variables in a formula

  • Thread starter Thread starter Brian Mann
  • Start date Start date
B

Brian Mann

I'm copying a formula to 100 different cells, and I want every cell t
maintain a reference to an array, but in another area of the formula,
want it to update with the corresponding row that it's on. Is there
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 wan
A1 to change to A2, A3, A4 and so on....

Any Suggestions?

Thanks
Bria
 
I did it again... so sorry... I found the answer...

I promise I won't cry wolf again!! :
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy COUNTIF while retaining reference 7
vlookup + if formula help! 7
How to use vlookup in an array formula 2
SUMIF function and cell /sheet reference 3
If formula-different numbers entries 2
Grouping & Formula 3
How to import data from Sheet1 to Sheet2 in the order I want 3
Combining Text From Cells 3

Back
Top