Tricky ... Pullout related rows that match a single word using Vlookup
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
|