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.
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 |