Creating a link by combining Data

Hello,

I am trying to find a way to dynamically create a external link for tracking. Here is what I want to do.

I have a list of shipments that are all sent via FedEx. I have the default link for FedEx on Sheet 2 Cell B2. The link is https://www.fedex.com/apps/fedextrack/?action=track&ascend_header=1&clienttype=dotcom&cntry_code=us&language=english&tracknumbers=

After the equal sign I need the tracking number

On Sheet 1 I have my list and n column D I have the tracking number.

I would like to combine the static information in Sheet2 B2 with the information in column D so that in Column E the result would be the word Track which would be a link to track the shipment.

Can this be done with a simple formula or do I need to use a VBScript?

Thanks!
JohnAsked:
Who is Participating?
 
anthonytrCommented:
Sorry, just realised you wanted a hyperlink.  You can use this to create the hyperlink you require:

=HYPERLINK(Sheet2!A2&Sheet1!A1, "Track")
0
 
anthonytrCommented:
Hi,

You can use a simple formula :

=(Sheet2!A2)&Sheet1!A1

Where Sheet2!A2 is where the Fedex Address is and Sheet1!A1 is the link on your Sheet1
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.