Try...

D1, copied down:

=IF(ROWS(D$1:D1)<=COUNTIF(A$1:A$7,"*sh"),INDEX(B$1 :B$7,SMALL(IF(RIGHT(A$1
:A$7,2)="sh",ROW(B$1:B$7)-ROW(B$1)+1),ROWS(D$1:D1))),"")

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article . com,
wrote:

I need some help w/ some excel coding. After reading the article "How
to look up a value in a list and return multiple corresponding values"
by Ashish Mathur
(http://office.microsoft.com/en-gb/as...260381033.aspx) I
would like to use this code but modify it so my "search" value can
include wildcards...

So in reference to the example at the Microsoft website (above),
instead of searching for "Ashish", I would like to be able to search
for "????sh" and return the multiple values for both "Ashish" and
"Rajesh"

Unfortunately I can't get this working and was wondering if anyone
could lend a hand.

Thanks in advance!
-bdh