View Single Post
  #3   Report Post  
YJL
 
Posts: n/a
Default 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