Hi,
I would like to search on 2 columns, to see if each cell in Column B contains text from any cell in Column A.
For example, IF the text in Column B (Email Address), Row 2 contains text from any cell in Column A (Domain) = True. Below is an example:
(A) DOMAIN NAME | (B)EMAIL ADDRESS | (C)TRUE OR FALSE?
hotmail.com | [email protected] | TRUE
msn.com | [email protected] | TRUE
web.com | [email protected] | FALSE
domain.com | [email protected] | TRUE
aol.com | [email protected] | TRUE
site.com | [email protected] | TRUE
I am currently using this formula:
=IF(ISNUMBER(SEARCH($A:$A,E2)),"TRUE","FALSE")
but it doesn't appear to be working. It only works if the matching rows are adjacent to each other. As you can see from the example above, the matching domains could be in any row, any cell.
Would anyone know the correct formula for this? I've searched everywhere Thank you!
Bookmarks