xmatch challenge

[KMunroe]

I am hoping some of the excel experts on this site can help me with an xmatch challenge i am having. I am trying to see if there is a way to use an xmatch to return the 2nd or 3rd instance of a list of dates without using a helper column.
I want to be able to look up a date and the instance number and have the xmatch formula return the ordinal position of that date and instance numbers... I have been struggling with this for several hours. Any help would be greatly appreciate3d.

Here is what I was trying to do.

 

[kevin9999]

I don't know about XMatch, but here's another way you could do it.

Book1
	A	B	C	D
1	Dates
2	Jan-22
3	Feb-22		Month	instance
4	Mar-22		Mar-22	2
5	Apr-22
6	May-22		Result:	15
7	Jun-22
8	Jul-22
9	Aug-22
10	Sep-22
11	Oct-22
12	Nov-22
13	Dec-22
14	Jan-22
15	Feb-22
16	Mar-22
17	Apr-22
18	May-22
19	Jun-22
20	Jul-22
21	Aug-22
22	Sep-22
23	Oct-22
24	Nov-22
25	Dec-22
Sheet1

Cell Formulas
Range	Formula
D6	D6	=SMALL(IF(A2:A25=C4,ROW(A2:A25)-ROW(INDEX(A2:A25,1,1))+1),D4)

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

From your talk of using XMATCH I assume you have other new functions like FILTER & SEQUENCE. If so, you could also try this.

22 03 29.xlsm
	A	B	C	D
1	Dates
2	Jan-22
3	Feb-22		Month	instance
4	Mar-22		Mar-22	2
5	Apr-22
6	May-22		Result:	15
7	Jun-22
8	Jul-22
9	Aug-22
10	Sep-22
11	Oct-22
12	Nov-22
13	Dec-22
14	Jan-22
15	Feb-22
16	Mar-22
17	Apr-22
18	May-22
19	Jun-22
20	Jul-22
21	Aug-22
22	Sep-22
23	Oct-22
24	Nov-22
25	Dec-22
KMunroe

Cell Formulas
Range	Formula
D6	D6	=INDEX(FILTER(SEQUENCE(ROWS(A2:A25)),A2:A25=C4),D4)