I have a column of cells in a Google Spreadsheet with values such as:
I'm generating hyperlinks in column B for each cell in column A:
xxxxx are values of the cells in column A:
The problem is that the formula requires to be filled down the rest of the column by the user.
I'd like to be able to paste the formula in any random cell in column B so that it takes the "link text" (xxxxx values from column A) from a parallel row in column A.
When the value in cell A455 is 37683 then pasting a formula into cell B455 will display 37683 as a link text and will take us to
When the value in cell A27 is 39873 then pasting a formula into cell B27 will display 37683 as a link text and will take us to http://mywebsite.com?id=39873
The formula needs to be universal so that the result is the same regardless of where in column B it is pasted.
How can this be done? Any workarounds welcome.