title: Return headers if column contains certain string
body: <p>I have a sheet called Input. The top row, A1:O1 contains the parent, and the rows underneath (of varying length) contains URLs. Some of the URLs are shared between the parents, and I want to return a list of URLs, and what their parents are. I have tried concatenate(if(index(match but the formula becomes too large. Similar questions I've seen are all looking for just one output, usually a number. I am open to VBA solutions, but have very very minimal understanding to create my own code. </p>
  
  <p>Example:<br>
  <strong>News --- Celebrity ---- Finance</strong><br>
  CNN------Complex --------Forbes<br>
  Forbes---CNN<br></p>
  
  <p>I want to return CNN News Celebrity, Forbes New Finance, Complex Celebrity. I don't mind how this output is formatted.</p>