Separating Comma Delimited Text for a Hyperlink

[wdgor]

The comma delimited cell below was created with: =TEXTJOIN(",",TRUE,IF(Cohort!$B:$B=A3,Cohort!$E:$E,""))

There are about 2,000 rows that are created on the sheet, all with varied text lengths. I want to be able to click on one of the comma delimited elements and hyperlink it to a the Cohort spreadsheet and do a lookup of that entry in Cohort!$E:$E. When I click in the hyperlinked cell, I get the whole cell contents and can't figure out how to select only one element, e.g. only C02957 and have it lookup that code on the Cohort sheet. Thanks in advance for your review and solution.

C02944,C02945,C02946,C02947,C02948,C02949,C02950,C02951,C02952,C02953,C02954,C02955,C02956,C02957,C02958,C02959,C02960,C02961,C02962,C03930,C06281,C00735,C00736,C00737,C00738,C00739,C00740

 

[zero269]

When I click in the hyperlinked cell, I get the whole cell contents and can't figure out how to select only one element, e.g. only C02957 and have it lookup that code on the Cohort sheet.

Excel only supports 1 hyperlink per cell that I'm aware of, so I'm not sure you can do what you're trying to do.
Perhaps this is better achieved by having the link for the cells that were used to TEXTJOIN instead?