inserting hyperlink

C

chuckie

I deal with spreadsheets that I create for our customers that involve
tracking numbers from both FedEx and UPS. I'm curious if anyone knows how to
'hyperlink' the aformentioned tracking number to the appropriate website. I
deal with 100 to 1,000 at a time and right now am using a script written by a
gentleman in our IT dept. While it works, it is quite slow. I think there
might be a way to do this by using the HYPERLINK formula but I can't seem to
get it to work. I am trying to get the tracking numbers to go directly to
the section of the website that shows the progress so that the customer
doesn't have to copy/paste and submit each one. Any solutions/suggestions
are appreciated
 
L

Luke M

Sure thing. Now, UPS and FedEx use different url setup, so you prb need to
use an IF statement. But here's how you could set it up.
A1 & A2 will contain URL structure for UPS
In A1:
http://wwwapps.ups.com/WebTracking/...peOfInquiryNumber=T&loc=en_US&InquiryNumber1=

In A2:
&track.x=0&track.y=0

For FedEx, in B1:
http://www.fedex.com/Tracking?language=english&cntry_code=us&tracknumbers=

Now, let's say you have you call out type in A4 (note that this could be
done via another formula possible, since FedEx uses all numbers...) and the
tracking numbers called out starting in B4. Formula in C4 would be

=IF(A4="UPS",HYPERLINK($A$1&B4&$A$2,B4),HYPERLINK($B$1&B4,B4))

Voila!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top