How to know if a cell contains a value from the given list

Question

Hello,&nbsp;I would like to get a true or false value on column B if column C contains any value on the list of column E.&nbsp;&nbsp;&nbsp;Can someone help me with the formula. This has been my frustration since yesterday and i wanna try my luck here. Hope somebody could help. Thanks in advance.&nbsp;

sergeibaklan · Answer

meldons06&nbsp;
As variant

that could be
=(SUM(COUNTIF(O4,"*"&amp;$P$4:$P$12&amp;"*"))-COUNTBLANK($P$5:$P$12))&gt;0

theantony · Answer

meldons06&nbsp;, in cell B2 try this formula:=ISNUMBER(SEARCH(E2,C2))&nbsp;

meldons06 · Answer

Hi, i tried but did not get what I needed. but i appreciate the help, thank you.

theantony · Answer

meldons06&nbsp;, can you upload a sample file with the data without any confidential info?

meldons06 · Answer

Hi&nbsp;TheAntonyHere's a sample excel file. Columns C and D are the sample data while Columns F-G and I-K are the outcomes i would like to have.&nbsp;On columns F-G, cells on column F will highlight if it has a value from the list on column GWhile on outcome 2, Column I will get "TRUE" if column J has a value from the list on column K&nbsp;Thanks for helping!&nbsp;

Forum Discussion

How to know if a cell contains a value from the given list

10 Replies

Resources