Forum Discussion
Compare cell value againt a string of text or data separated by comma in another cell
I have 2 lists of data in 2 different columns as "Set 1" and "Set 2". The value in cell (A2) under "Set 1" need to be compared with text in cell (B2) under "Set 2" and it can have comma separated values to be compared against and can also have duplicates values in it. I would like to find matching value for A2 in B2 (First one if there are duplicates) under "Set 2" and return it under "Match" i.e Column C and apply the same condition for the rest of the rows
6 Replies
Thank you, that is almost what I was looking for. I believe there a small tweaking required though. Its not picking the value if it is not the first one in the cell. Just to clarify from my example, in row 2, its not picking PB and giving a blank as that was not the first one in the cell but its helped in row 3 cause PB is the first value in it and returning it. Same problem in row 4 & 5 and working in row 6 again and so on.
