Match with criteria and starting index

[mrblister]

Can someone please help me with the following. I would like a formula that returns a position in a range, upon matching the first item that matches criteria BUT only start searching from a given position.

For example, for the following range there are the following values: [0,1,0,1]
If criteria is X>0, and start looking after position 2, then the formula should return: 4

But I can't get it to work. I tried the following formulas, but both of these return: 2.
MATCH(1,(O221:O224>0)*(ROW(range)>2),0)
XMATCH(1,INDEX((O221:O224>0)*(ROW(range)>2),0),0)

It would obviously be easier if I simply entered in a shortened range, but I'm not able to do that (the above formula would be deeply embedded in a much larger formula with dynamic ranges).

Can anyone assist?

 

[DanteAmor]

The result would be row 4 if the data started in row 1, but in this case you must consider that the data starts in row 221.
Try:

varios 13dic2024.xlsm
	O	P	Q
220
221	0		4
222	1
223	0
224	1
225
Hoja8

Cell Formulas
Range	Formula
Q221	Q221	=LOOKUP(2,1/(($O$221:$O$224>0)*(ROW($O$221:$O$224)>ROW($O$221)+2)),ROW($O$221:$O$224)-ROW($O$221)+1)

 

[mrblister]

Thank you, but do I edit the position variable by editing the "+2"? If that's the case, if I set it to "+0", then the formula should return "2", but it instead returns "4".

 

[Cubist]

Try:

Book1
	A	B
2	0	4
3	1
4	0
5	1
Sheet2

Cell Formulas
Range	Formula
B2	B2	=XMATCH(1,(A2:A5>0)*(SEQUENCE(ROWS(A2:A5))>2))

 

[mrblister]

Try:

Book1
	A	B
2	0	4
3	1
4	0
5	1
Sheet2

Cell Formulas
Range	Formula
B2	B2	=XMATCH(1,(A2:A5>0)*(SEQUENCE(ROWS(A2:A5))>2))

Works great! Thank you!