hi everyone,
so i have a series of columns. in one of the columns, each row contains a number of phrases separated by commas that are also column headings. what i want to do is if the column heading is contained in the row of column a, then 1, if not, then 0.
so I have =IF(A2=B1,1,0) then =IF(A2=C1,1,0) etc. i think i need to put the actual phrases in quotes to draw out of the row and compare to the column heading?