I need a formula to search column B for the content in column A.I want a true/false answer
A1:/EV164014 B1:/HA4/EV164014 true
A2:/EV164021B B2:/HA3/EV164021B true
A3:/EV164028 B3:/STUDY2500/10ESD false
Can somone help me?
I need a formula to search column B for the content in column A.I want a true/false answer A1:/EV164014 B1:/HA4/EV164014 true A2:/EV164021B B2:/HA3/EV164021B true A3:/EV164028 B3:/STUDY2500/10ESD false Can somone help me? 


Try this:
I would then put this in column C. It searches for the value in the adjacent cell in A, anywhere in the range of cells in B, if it finds something then there is no error so it ISERROR returns FALSE, and the IF statement returns TRUE, otherwise it returns FALSE. 


At first glance I would suggest the formula
as that will perform better and is also more concise. It will return a TRUE if it finds one or more exact matches. Looking at your data however, it looks like you want to know if the value of cell A1 was contained in the value of cell B1 (and so on). For that matter this formula should do:


