Creating number comma (or semi-colon)-delimited values outputfrom separate look-up table and commas/semi-colon text values

[DCard]

Creating number comma (or semi-colon)-delimited values outputfrom separate look-up table and commas/semi-colon text values

so i want to manually enter or copy comma (or semi-colon - not both ) text labels in Categories-Manual column, look up text value match in category look-up table and create the relevant comma (or semi-colon codes) in categories-code column

kind regards

don

 

[DCard]

many thanks

 

[Peter_SSs]

Still don't have data to test with but try

=SUBSTITUTE(TRIM(IFNA(INDEX(Categories!B$2:B$100,MATCH(F5,Categories!A$2:A$100,0),1),"")&" "&IFNA(INDEX(Categories!B$2:B$100,MATCH(G5,Categories!A$2:A$100,0),1),""))," ",",")

 

[DCard]

i sent screen shot before again with data

 

[DCard]

works PERFECTLY. i didn't even have to edit cell references!!

thanks so much

 

[Peter_SSs]

i sent screen shot before again with data

Yes but only the formula sheet, not 'Categories' so there was no way to actually see how 112,111 was obtained or why the other formulas returned #N/A

works PERFECTLY. i didn't even have to edit cell references!!

thanks so much

Good to hear! You're welcome.