Links From a Cell Value
Key points
- Choose CELLURL
- Enter the URL prefix
- Copy it
In HYPERLINK Builder you join a URL prefix and a cell value to make a link for each row.
Steps
- Choose CELLURL
- Enter the URL prefix
- Copy it
It suits links built on IDs such as product numbers.
Use "Build a HYPERLINK Formula" (free)
Tools that go well with this
- Build an IMPORTRANGE Formula: Build an IMPORTRANGE formula.
- Build a TEXTJOIN Formula: Build a TEXTJOIN formula.
- Build an IF Formula: Build an IF formula.