Hello!
I am having trouble slimming down an array formula and am looking for suggestions. The below is part of a Index/Match array formula. What I want to do is make the Criteria portion of COUNTIF (the end range of 'Sheet2'!T$2:$T$250) based off the cell value in A1.
If A1 = 12, then it should be T$2:$T$12, instead of $250.
I've tried adding Indirect and Concatenate, as below, but it isn't working.
Thank you for your insight!
I am having trouble slimming down an array formula and am looking for suggestions. The below is part of a Index/Match array formula. What I want to do is make the Criteria portion of COUNTIF (the end range of 'Sheet2'!T$2:$T$250) based off the cell value in A1.
If A1 = 12, then it should be T$2:$T$12, instead of $250.
Code:
{=MATCH(0,COUNTIF($A3,'Sheet2'!T$2:$T$250),0)}
I've tried adding Indirect and Concatenate, as below, but it isn't working.
Code:
{=MATCH(0,COUNTIF($A$3,'Sheet2'!T$2:INDIRECT(CONCATENATE("T",A1))),0)}
Thank you for your insight!