Clever Geek Handbook

Dynamic hyperlink using formula

I need to use id in url hyperlink like this example:

http://www.wotnots.co.uk/property/images/property2402_image1.jpg

The ID here is 2402. I want to change it to the ID number which is in the first column and is different from each row. I want the tracking number to be the same as the number in the hyperlink.

0


source to share


3 answers


I would use the HYPERLINK cell function to create a link. For example:

Cell A2: 2402
Cell B2: =HYPERLINK("http://www. ... /property" & A2 & "_image1.jpg","Click to see ...")


Then you can copy the formula to all the following lines, and the reference to cell A2 will change relative to the current line.

This can also be generated dynamically using VBA code if needed.

+3


source


Here you go.



=Concatenate("http://www.wotnots.co.uk/property/images/property",$A1,"_image1.jpg ")

+1


source


Try the following formula:

="http://www.wotnots.co.uk/property/images/property"&A1&"_image1.jpg"
+1


source






More articles:


All Articles