how to get the corresponding value of based on criteria?

[liyifeng]

do we have any easy way to achieve the below? just want the value corresponding to criteria DLR

	111​	A	B	C	D	…
		a	b	c	d	…
		DLR	bb	cc	DLR	…
	222​	E	F	G	…
		e	f	g	…
		ee	DLR	gg	…
	…
	output should be
	111​	A, D
	222​	F

 

[Anthony47]

In the upper table does each block have 3 lines beeing the criteria on the third line, or which are the rules?