using wildcards for text in index/match multiple criteria in Excel

[Tony Tony]

I'm having trouble using wildcards for text in index/match multiple criteria; I need to find the nearest site along a river (x) below a certain point (distance =21), each stretch of the river is labelled with the streches downstream (so stretch abc is upstream of ab).
My problem arises when the nearest point downstream is on the downtsream stretch of river.
How do I use wild card to search for ab&"*" that will exclude abd.
Any help would be greatly appreciated.

Tony

Site	River	Distance	Stretch
S1	x	10	a
S2	x	15	ab
S3	x	20	ab
S4	x	22	abd
S5	x	25	abc
S6	x	30	abc
S7	y	10	a
S8	y	15	ab
S9	y	20	ab
S10	y	22	abd
Riv	Dist	Stretch	Expected	Calculated
x	21	abc	S3	#N/A
x	27	abc	S5	S5

<tbody>
</tbody>

'formula in cell E14 ={INDEX(A2:C11,MATCH(1,(A14=B2:B11)*(C2:C11<b14)*(c14=d2:d11),0),1)}< html=""></b14)*(c14=d2:d11),0),1)}<><B14)*(C14=D2:D11),0),1)}
tried: INDEX(A2:C11,MATCH(1,(A14=B2:B11)*(C2:C11<B14)*(IF(COUNTIF($D2:$D11,C14&"*")>0,1,0)),0),1)

 

[Tony Tony]

<b14)*(c14=d2:d11),0),1)}
<b14)*(if(countif($d2:$d11,c14&"*")
</b14)*(if(countif($d2:$d11,c14&"*")
</b14)*(c14=d2:d11),0),1)}>'formula in cell E14 ={INDEX(A2:C11,MATCH(1,(A14=B2:B11)*(C2:C11<B14)*(C14=D2:D11),0),1)}

 

[Tony Tony]

<b14)*(c14=d2:d11),0),1)}< html="">
formula in cell E14 ={INDEX(A2:C11,MATCH(1,(A14=B2:B11)*(C2:C11 is less than B14)*(C14=D2:D11),0),1)}</b14)*(c14=d2:d11),0),1)}<>

'also tried something along these lines to no avail =INDEX(A2:C11,MATCH(1,(A14=B2:B11)*(C2:C11 is less than B14)*(IF(COUNTIF($D2:$D11,C14&"*")>0,1,0)),0),1)