Can a string of data be returned when you match 2 criteria?

[HockeyDiablo]

Just curious if a string of data can be returned if a set of criteria is met:
Here is where I am going with this.

	A	B	C	D
1	123 Main Street Las Vegas, NV 88888		Criteria	456 My Avenue Miami, Florida 55555
2	456 My Avenue Miami, Florida 55555		Avenue
3	789 Their Boulevard, Houston Texas		Florida

<tbody>
</tbody>

String I'll search are in A:A, Criteria desired C2&C3, Return find in D1

 

[HockeyDiablo]

=INDEX(A1:A3,MATCH(c2,A1:A3,-1))

I can figure out how to incorporate the other criteria(c3)

 

[Muhammad_Usman]

TRY This one in D24 =IF(AND(FIND($C$24,B24),FIND($C$25,B24)),B24,0)

 

[HockeyDiablo]

=IFERROR(INDEX($A$1:$A$5, SMALL(IF(ISNUMBER(SEARCH($C$2&" "&$C$3, $A$1:$A$5)), MATCH(ROW($A$1:$A$5), ROW($A$1:$A$5))), ROW(A1))),"No Match")

Returns some data but not all...

 

[Aladin Akyurek]

In D1 enter:

=LOOKUP(9.99999999999999E+307,SEARCH(C2&"*"&C3,$A$1:$A$3),$A$1:$A$3)