Create a hyperlink with query string from cell

[Portucale]

Hi all....

I have an Excel column that contains unique numbers, and I have
Web reporting that reports on those numbers. What I would like is for the user to click on the Unique ID, or in a another cell with the link, and populate into a web form the same Unique ID which then the form would be populated accordingly, currently I have the following formula in a different column but don't seem to work

HYPERLINK("http://www.mywebsite.com?param=("&A2")")

Any help is very much appreciated.

Kind regards,

 

[lohithsriram]

Hi Portucal,

Did you check the syntax of the formula? Ampersand(&) is missing and that could be areason not to make a proper hyperlink.
Try this.
=HYPERLINK("http://www.mywebsite.com?param=("&A2 &")")

 

[Portucale]

I feel dumb... :'(, many thanks for the hint and solution