CODEWITHSUNDEEP
excelexcel-formula
Rene Hunger
Rene Hunger

Reputation: 25

Multiple data separated by comma into different columns

I have a problem and I can't seem to get my head around it.

Basically I have a table where in column B different tools are listed:

RAW

All of them are separated by a comma. Now I want to get rid of column b and fill the data into the corresponding columns.

So that at the end it look like this

Desired End Result

I tried with a regular VLOOKUP but that did not work at all. Then I tried with an IF formula, but I can't get my head around how I make the criteria.

=IF([@Equipment]=Table2[[#Headers];[Tool1]];"Yes";"No")

Upvotes: 0

Views: 109

Answers (1)

Hooded 0ne
Hooded 0ne

Reputation: 997

=IF(ISNUMBER(FIND(C$19,$B20)),"YES","NO")

enter image description here

Upvotes: 1

Related Questions