Arte SheetsLearn. Try. Understand.

Lookup & Reference

HYPERLINK function: build dynamic clickable URLs and sheet jumps from cell values

Combine base URLs with ticket IDs or tracking numbers using HYPERLINK and display concise friendly labels.

Open spreadsheet ↗

Dynamic tracking and ticket URLs

HYPERLINK(link_location, [friendly_name]) constructs a clickable URL from cell data while displaying the concise friendly_name in the cell (or link_location when friendly_name is omitted).

Guard against blank IDs with IF so empty rows do not display broken link labels.

=HYPERLINK("https://example.com/orders/" & A2, "Open " & A2)

Try the example

Use the original values or change them to test your understanding.