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.
Example:
News --- Celebrity ---- Finance
CNN------Complex --------Forbes
Forbes---CNN
I want to return CNN News Celebrity, Forbes New Finance, Complex Celebrity. I don't mind how this output is formatted.
Aucun commentaire:
Enregistrer un commentaire