Two way look up with mutiple duplicate criteria with mutiple return

[sanrama]

Hi

I am not able to apply formula in G6, tried to applly =IFERROR(INDEX($C$3:$C$30, SMALL(IF(1=((--($E$3=$A$3:$A$30)) * (--($F$3=$B$3:$B$30))), ROW($C$3:$C$30)-2,""), ROW()-2)),""), but failed.

	A	B	C	D	E	F	G
1	Cost	Spending	Date
2	B	4,50,000	16-01-2024
3	B	5,50,000	09-02-2024
4	B	3,37,500	17-06-2024
5	B	33,00,000	17-06-2024		Cost	Spending	Data
6	B	12,47,500	24-06-2024		B	4,50,000	16-01-2024
7	B	2,40,000	04-06-2024		B	5,50,000	09-02-2024
8	Q	20,000	04-02-2024		B	3,37,500	17-06-2024
9	C	50,000	09-08-2024		B	33,00,000	17-06-2024
10	C	50,000	03-08-2024		B	12,47,500	24-06-2024
11	P	14,000	16-07-2024		B	2,40,000	04-06-2024
12	P	30,000	01-07-2024		B	2,25,000	08-09-2024
13	AC	61,000	28-07-2024
14	CA	2,50,000	27-06-2024
15	A	20,000	10-08-2024
16	A	15,000	22-08-2024
17	A	1,00,000	23-08-2024
18	P	5,000	08-09-2024
19	B	2,25,000	08-09-2024
20	C	50,000	30-08-2024		F6	IFERROR(INDEX($B$3:$B$23, SMALL(IF(($A$3:$A$23=$E$7), MATCH(ROW($A$3:$A$23), ROW($A$3:$A$23)), ""),ROWS($A$1:A3))),"")
21	C	25,000	09-09-2024		G6	??
22	CA	50,000	12-09-2024

 

[Kaper]

If it is working as expected (I've not tested), then why not change just range in Index function?
So :

=IFERROR(INDEX($C$3:$C$23, SMALL(IF(($A$3:$A$23=$E$7), MATCH(ROW($A$3:$A$23), ROW($A$3:$A$23)), ""),ROWS($A$1:A3))),"")

 

[sanrama]

If it is working as expected (I've not tested), then why not change just range in Index function?
So :

=IFERROR(INDEX($C$3:$C$23, SMALL(IF(($A$3:$A$23=$E$7), MATCH(ROW($A$3:$A$23), ROW($A$3:$A$23)), ""),ROWS($A$1:A3))),"")

It works perfectly

Thanks Kaper

 

[sanrama]

I didn't even think of that
Smart thinking

Thanks again