CODEWITHSUNDEEP
excel-formula
Greg Mein
Greg Mein

Reputation: 11

referencing an array that's stored in a cell within a formula

=INDEX($AT$1:$AY$66,MATCH("REGULAR PAY *",$AT$1:$AT$66,0),3)

Because I use this same array value ($AT$1:$AY$66) in multiple formulas across the sheet (and it could change at some point) it would be nice if I could put $AT$1:$AY$66 into a cell and reference it within this formula. So far I haven't had any luck being able to do that.

Upvotes: 0

Views: 123

Answers (1)

Greg Mein
Greg Mein

Reputation: 11

I've managed to get past this now by using INDIRECT(BF7) in place of my AT1:AY66 where BF7 is where I have AT1:AY66. Now if it happens that I need to change that array to AT1:AY70 for example I can just change it in BF7 and it will alter all my formulas accordingly.

Upvotes: 1

Related Questions