On my 'Orders' worksheet, I am using some script to populate the Item column based on the chosen Style value.
EXAMPLE GOOGLE SHEET
Double click any empty cell in the Style column choose CODE 3 - the Item column will automatically populate with ITEM 3. It retrieves this data from the 'Styles' worksheet.
I am also storing a single URL for each item. When the script runs and populates the Item column, I would like that value to be clickable, and point to the URL stored in the 'Styles' worksheet.
So in the above example, everything would work the same - but Item 3, if clicked, would open www.item3.com
I'm wondering if this is at all possible.
Thank you in advance for any help.
Bookmarks