Provided I've got your requests right, here's a way:

descr name addr succ
2 Fred NY yes
4 Michael Chic no
8 Mary Bost yes

Search
4
results
descr name addr succ
4 Michael Chic no

Your data in A2:D4
Your search criterion in A7

Type in A9:
=OFFSET($A$2;MATCH($A$7;$A$2:$A$4;0)-1;COLUMN(A9)-COLUMN($A9))
copy across to D9

That gives the above results.

Hope this is it?

Hans