Inserting hyperlinks on excel

**joseph_yap22** · 05-10-2012, 06:37 AM

Hi again dear Wizards,

Please help me to automate my spreadsheet.

I want to automate cell A1 for example that if I encode particular data and data itself will convert to a hyperlink that will direct to a particular website.

If a A1 contains letters "SAFM"+any number like (SAFM556483055) it will convert to a hyperlink and whenever I click it, it will direct me to this website address [http://mysaf2.safmarine.com/wps/port...afmarine/Home]

and, MAEU999999999 to http://www.maerskline.com/appmanager...g3_trackSimple

and MSCHH9999999 to http://www.mscgva.ch/tracking/index.html

Please... and thank you sooooo much!

**NBVC** · 05-10-2012, 08:08 AM

Create a table on the side of the 4 letter acronymns and in the next column put the associated websites.

Now assuming you have MAEU999999999 in A1, and you put the table in J2:K3, then use formula:

=HYPERLINK(VLOOKUP(LEFT(A1,4),$J$2:$K$4,2,0))

adjust ranges to suit.

**joseph_yap22** · 05-10-2012, 08:18 AM

Hi sir! Nice to meet you again here.

Is the MAEU999999999 itself here will become a hyperlink? like it will show as an underlined blue-colored text?

Thnaks.