Advanced hyperlink

[xeknar]

I have a long column of data, containing a different number in each row and I want each number to be in a hyperlink that remains static exept for the value of the number.
for example
c1 = 356
c2 = 886
c3 = 936
c4 = 387

if the address is http://example.com/example.php?page=internet&var2=XXX

where the xxx is one of the numbers from each row, I am wondering if I can somehow autofill so each number has a hyperlink attached to it in the document, leading to the correct address for example in c1 you would just see the number 356 hyperlinked, and the adress would be http://example.com/example.php?page=internet&var2=356

[FDibbins]

I cannot test this, because I cant link to what you are refering to. but try this...

=HYPERLINK(INDIRECT(" http://example.com/example.php?page=internet&var2="&C1))

[xeknar]

I am getting a #REF! error

[xeknar]

those addresses are just hypothetical, :P sorry about that

[xeknar]

=HYPERLINK("http://example.com/example.php?page=internet&var2="&C3,C3) works exactly how I would want it to, except it requires me to have a separate column without hyperlinks to reference to and I end up getting two identical columns, one with and one without hyperlinks

[xeknar]

nm I just made a whole new tab and then used =HYPERLINK("http://example.com/example.php?page=internet&var2="&Sheet1!C4,Sheet1!C4) it auto filled out perfectly and I never have to look at the tab without the hyperlinks, it just sits in the background

[xeknar]

Thank you very much FDibbins, without you pointing me in the general direction, I would have never figured this out!

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)