I have utility that I've been working on (modified from an existing sheet) for a Tabletop game I run for my group.
Currently, it generates random items from a list. The name of each of the items has a corresponding hyperlink to the items description from the same sheet.
My goal is to populate a new cell with with BOTH the item's name, and it's description.
So, if the generator returns an item name in cell "C4" with a hyperlink to its corresponding description cell, what formula should I use to populate this new cell (or cells) with both the name, and the descriptor?
Clicking the hyperlink routes you to the corresponding "Description" cell. [3
My ideal behavior, is for the formula to insert both the Name and the Descriptor into the new cell.
Any advice or ideas would be appreciated.