| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Tricky ... Pullout related rows that match a single word using Vlookup
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to add word to the front of every word in all rows automatica. | Excel Discussion (Misc queries) | |||
| in an excel macro can you import data from word into a cell? | Excel Discussion (Misc queries) | |||
| inserting rows at common word in a sheet | Excel Discussion (Misc queries) | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Threaded Mode
