How to form an array within a formula?

[hrithik]

I need to form this array RANGE = {0,1,($A$2*$B2)+1,($A$3*$B2)+1} and feed it to in the formula MATCH($c2,RANGE,1)

How could I do this? I need a single formula

 

[Marcelo Branco]

Hi,

Maybe this array formula

=MATCH(C2,IF(ROW(1:4)=1,0,IF(ROW(1:4)=2,1,IF(ROW(1:4)=3,A2*B2+1,A3*B2+1))),1)
Ctrl+Shift+Enter

HTH

M.

 

[shg]

Or =MATCH($C2, CHOOSE({1,2,3,4}, 0, 1, $A$2*$B2 + 1, $A$3*$B2 + 1), 1) entered normally