I have a list in Sheet1 in below format
ColA ColB
abc 1,2
cde 3,4
In Sheet2, I added a dropdown list to the range C1:K10 and the list contains value abc, cde, dfg. This list allow selection of multiple values in the same cell For ex, cell C1 can have value abc, cde; ce;; C2 can have...