Keeping variables in a formula

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
 
B

Brian Mann

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

I promise I won't cry wolf again!! :
 
Top