rearrange 3 columns to match a list

[John Caines]

Hello all.
I really am struggling here.
I have a long list of URLs In Column B2. Column A is just numbered, From A2 (1 to 984)

And I have data in columns, C2, D2 & E2
Column C2 also has a list of URLs.

Here's what I'm trying to do.

I really need a formula to look at the URLs in COL B, (And this column of URLs does contain duplicates which I must keep), and see what URLs match with this from COL C.
When there is a match, put all 3 cells from columns CD & E onto the same ROW as the matching URL

Does this make sense?
Here's a screenshot as an example

no	url (COL B)	new (COL C)	server (COL D)	php (COL E)
1​	Want your own website? | 123 Reg	24S | Luxury Fashion: Women's and Men's designer clothes, bags & shoes	Apache	N/A
2​	http://2diggers.co.uk/	http://www.2catanddod.com/	Apache	PHP/7.0.33
3​	http:/star-classics.co/	http:/star-classics.co/	Apache	N/A
4​	http://www.2catanddod.com/	Want your own website? | 123 Reg	Apache	N/A
5​	http://4256constructionltd.com/	http://2diggers.co.uk/	Apache	N/A
6​	http:/star-classics.co/	http://4256constructionltd.com/	Apache	PHP/5.6.40

So, it's;
1. Make Col C, D, & E all rearrange so COL C URLs along with Col D & E) rearrange to the same order as Column B URLs.

I really hope this makes sense.

Hope someone can help me out here.
I'm trying to find this on the forum, as I'm sure this must have been done many times, but I just can't see it!

Hope someone can save my day!

Many thanks in advance

Best regards
John C

 

[Peter_SSs]

You're welcome ... but ...

So, for cell H2:I985 I have

=INDEX(D:D,AGGREGATE(15,6,ROW(D$2:D$985)/($C$2:$C985=$G2),1))

& all is now good I think.

... that would really be best as

=INDEX(D:D,AGGREGATE(15,6,ROW(D$2:D$985)/($C$2:$C$985=$G2),1))

 

[John Caines]

Hi Peter,
Many thanks for your reply again and advice.

I'll amend the formula now.
Definately saving this sheet as I know it will be very useful for me sometime in the future.

Thanks again Peter for all your help.
Best regards
John Caines

 

[Peter_SSs]

No problem Glad to help.