Using Multiple Variables to Return Multiple Variables

Somebody wonderful gave me this cool macro which allowed me to return multiple variables from a single term. It worked flawlessly. In fact I used it on two other projects and had no problems. Naturally that couldn't last. Now, if you look at the Video Links tab, I have a column, J, which contains multiple variables. I want it to pull the concatenated data in column E into a single line of data for each term. If the T1 through T16 designations come along for the ride that's fine. I can use Ctrl+H with the best of them and make them go away. You'll see the macro I attempted to use labeled multiplefind2. Obviously, any and all help is appreciated.

Thanks.

Sure can. Each value in Column J corresponds with corresponds with one in Column E. There are multiple values in Column J. So, for example, J2 should return the example in the attached text file. The links I showed set off every fire wall warning up here so I couldn't pop them in the thread.

And thanks for the heads up. The other sheets were formatted the same so I never checked the Tab designation.

I don't want to match to the terms. I've done that. Now I want to bring up all the video files, Column E, that match the items listed in Column J, T1, T2, T3, etc.

Not a problem. I want it to loop through column J on the Video Links tab and find matches in column E in the same tab. Then I want those results returned in a new column. K would be fine.

If you look at column A you will see rows named T1, T2, etc. Column B has an iFrame script. I concatenated them in E to keep them together. If you look in J you'll see T1, T2, designations for each of the 100 words matched in Column I. I is just for my reference. What I need is the values in J to return matches from E or B, whichever works best. There is a match for every item there.

Okay, we're headed in the right direction. Since I was on a tight time frame I did what I needed manually, but I'm sure I won't be the last to need something like this so I'll leave the thread open. The designations in column J refer to all the uses of the terms in column I to describe the tracks in column A. The T1, etc., designations specify tracks. T1 = track 1 and so on. So for J2, I'd need it to pull back E14 and E17 as results.

I hope that helps.

Okay, I'm attaching a sample spreadsheet that will, God willing, avoid any confusion. J2 pulls up two values and J11 pulls up one.So J2 looks for T13 & T16 and then returns them both to column K. J11 is only looking for T7 so it only returns that value to column K. I've eliminated the other sheets since they seem to be making things more confusing than I intended.

I truly appreciate your time with this. Based on the way my life ebbs and flows I'm pretty sure this will come up again for me.