VBA - Multiple values in a cell (comma separated) and return the corresponding values to a single cell (comma separated) with characters more than 255

[Hari1992]

Hi,

I am looking for a VBS/ formula for the following. Here I am trying to achieve Dynamic Lookup for multiple values in a cell (comma separated) and return the corresponding values to a single cell (comma separated also). I am able to populate the B13 through the formula with Barnames column which has less than 255 char, but not working for B14 which has more than 255 char. Could someone suggest to me the Formula/Macro/VBS achieve this?

Thanks in advance,

Cell Formulas

B4- =REPT("-",255)

C4- =REPT("-",255)

B13- =TEXTJOIN(CHAR(10),1,IF(ISNUMBER(FIND(","&$A$4:$A$7&",",","&A13&",")),$B$4:$B$7,""))

B14- =TEXTJOIN(CHAR(10),1,IF(ISNUMBER(FIND(","&$A$4:$A$7&",",","&A14&",")),$C$4:$C$7,""))

 

[Fluff]

Glad we could help & thanks for the feedback.