Dear Gurus . ...

I have a worksheet with 5 columns and 400 rows. All contents are sentences.
I use Vlookup but it only can show result that matches the input exactly.
How to ask vlookup to retrieve all the sentences that match my single input?
And how to ask vlookup shows multiple searching result? (It stops after getting the first from top)

Please help. Thanks in advance.

YJL