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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]123 Main Street Las Vegas, NV 88888[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Criteria[/TD]
[TD="align: center"]456 My Avenue Miami, Florida 55555[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]456 My Avenue Miami, Florida 55555[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Avenue[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]789 Their Boulevard, Houston Texas[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Florida[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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)