I'm trying to create a formula that will allow all the cells in Column
B to include a hyperlink to cells in Column
J in their corresponding rows. The kicker is that I'm trying to keep the current values of the cells in Column
B as the title of the hyperlink.
I've been trying different iterations of:
but it doesn't appear to function the way I've intended.
Any thoughts or advice would be appreciated.
Using the advice provided by marikamitsos, I was able to adjust my formula to something very close to what I am looking for, but it still isn't the exact behavior I'm trying to achieve.
This array formula pulls names from one column, and then embeds a hyperlink to the entire range of descriptions. However, the link does not direct you to the corresponding cell containing the description for the exact item.
produces the correct behavior, but only for a single cell in the name range. Due to there being 632 entries, I was hoping that a proper
ArrayFormula could provide and iterative range, so that K2 links to J2, K3 to J3 and so forth. Any further clarification on syntax would be greatly appreciated. Or, if I'd be better off with a macro or script.