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