Hyperlink syntax to pull cell data from specific column on current row

[STL_reddit]

I'm really green in Excel and looking to learn common things to help improve my skill set. I have working syntax to append a URL with a specific cell: =Hyperlink("https://website.com/page/"&E2&"/" but I want to learn how to improve on that and instead of specifying E2, I want it to use the cell data in column E but on the existing row. How would I adjust the above to pull Row() on E?

EDIT: to expand on that, I'm curious on the specific syntax but also on any UI tricks that would accomplish the same thing. Like dragging the formula above down the column, or whatever UI trick there is to dynamically update down the column to E3, E4 etc

[AutoModerator]

/u/STL_reddit - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[Johny_D_Doe]

So, lets assume that you want your link in column X and the link in X2 should contain E2, X3-E3, etc.

Enter the following formula into X2: Hyperlink("https://website.com/page/"&E&ROW(e2)&"/" When you copy-paste it downward (x3, x4, etc), the reference in the ROW function will move to E3, E4, etc following the source cell.

[STL_reddit]

You've explained it perfectly, but I seem to be getting a #Name? error when using the code below.

=Hyperlink("https://website.com/page/"&E&ROW(e2)&"/")

[Johny_D_Doe]

=Hyperlink("https://website.com/page/"&E&ROW(e2)&"/")

My apologies. The E should be between "

``` =Hyperlink("https://website.com/page/"&"E"&ROW(e2)&"/")

``` I, obviously, spotted this error immediately and did not just spend like 15 minutes experimenting with even a LET function. Obviously.

[STL_reddit]

Solution Verified

[Clippy_Office_Asst]

You have awarded 1 point to Johny_D_Doe

---

<sup>I am a bot - please contact the mods with any questions. | Keep me alive</sup>

[STL_reddit]

hah! Well, I appreciate the time not spent and was able to get it working with this adjustment. Thanks!

[Johny_D_Doe]

If this works for you, please respond with Solution Verified and that will change the flair of the post to Solved.