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


--
YJL
------------------------------------------------------------------------
YJL's Profile: http://www.excelforum.com/member.php...o&userid=28693
View this thread: http://www.excelforum.com/showthread...hreadid=484200