I have a Numbers spread sheet with peoples names and I want to link each name to a photo of that person
Plus I have a date and want to link to a letter in Pages
Plus I have an address and want to link it to a map in Maps
I dont want to use Excell with Word, unless there's no alternative
MacBook Pro 13″, macOS 15.1
It sounds like HYPERLINK() is the function you're after.
You use HYPERLINK() with two arguments - a URL, and an optional text field that's displayed in the cell, e.g.:
=HYPERLINK("https://maps.apple.com/?address=10600 N Tantau Ave, Cupertino, CA 95014, United States&lsp=9902&q=Apple Park Visitor Center&t=m, "Apple Visitors Center")
You can construct the URL using values from other fields, too.
This will work for HTTP/S and mailto: links, but you cannot use it to reference a local file on disk, so your Pages document isn't an option.
How do I link a cell in Numbers to a document in Pages