| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Tricky ... Pullout related rows that match a single word using Vlookup
Hi!
Ok, I'm not sure what you're trying to do. Vlookup can only search the leftmost column of a range and return data from the nth column to the right. So, Vlookup will not do what I think you want. Have you tried filtering? Biff "YJL" wrote in message ... Here is my example. I want to search "abc" Data A B C D E 1 abcde fghij klmno pqrst uvwxy 2 fghij klmno pqrst uvwxy abcde 3 klmno pqrst uvwxy pqrst uvwxy 4 edabc fghij klmno pqrst uvwxy |
| 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
