Dynamic hyperlink based on groupins

Team,

I need your help with an Excel formula.

For a particular Group (Column E) i would like to use a dynamic formula to create a hyperlink

The hyperlink can be broken down into 5 elements


1)https://salesforce.com/merge/conmerg...?goNext=+Next+
2)&p2=0033a00002WiusT
3)&cid=0033a00002WiusTAAR
4)&cid=0033a00002QOJhsAAH
5)&cid=003f100001pOrHCAA0

1) Always remains the same
2) This id should be the "Master Id (Column C) for every Group (Column E)
3) This id should be one of the "Id"s (Column A) for every Group (Column E)
3) This id should be one of the "Id"s (Column A) for every Group (Column E)
3) This id should be one of the "Id"s (Column A) for every Group (Column E)

Expected out come

Group Id 64

HTML Code: 

Group Id 120

HTML Code: 

I may be missing something but your 3,4,5 parts dont flow into the structure of this file...

=HYPERLINK() is all you need... if you can build the text inside you should do that... the layout of this doesnt make sense with what you are asking OR you need to put this into an array that adds the mid sections.

Can you not store the data in 5 columns for the 5 parts? why do you stack it if there are parts that belong to a previous group...

Put this in F5

Please Login or Register  to view this content.

Just want to point out that the 3rd ID does NOT match your URL ...there is a J trailing in the data that you provided but not in the URL you cite for group 120