Create link based on other data from columns

[alex_345]

Hello,

I am trying to have excel create a tracking link based on which carrier an employee selects in Column G and the tracking # in Column H. Since each carrier tracking has similar link formatting, I would copy their link, but just need to change the tracking # part of it ... for example, Purolator: Tracker where the number after "pin=" would change for each link, like the other carriers. I just need to create a link in Column I, based on the conditions. I could also store the link starts somewhere within the workbook, if needed to make this work.

Any solutions to do this ... formulas, formatting, commands? I would appreciate it!


This is a sample of what our workbook already looks like:

 

[Fluff]

Duplicate to: Create a tracking link based on data from two cells

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.