the text a link displays — clickability is the renderer's · from excel · excel: differs in detail · sheets: differs in detail

signature

HYPERLINK(link_location, [friendly_name])

returns: text

argument	required
link_location	required
friendly_name	optional

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

related

• ADDRESS returns a cell address as text from row and column numbers
• AREAS returns the number of areas in a reference
• HLOOKUP searches first row and returns matching value
• INDEX returns value at row and column in range
• INDIRECT returns reference specified by text string
• LOOKUP looks up value in one-row or one-column range