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

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