I am looking to have the function look for multiple terms inside of cell to return a "X" as a check if there is a match. The formula only works on the first part of the formula. So I tried working in AND. It then only gives an NA
=IF(AND(MATCH("*City of Grand Rapids*",R6,0),IF(MATCH("*City of Grandville*",R6,0),"X")))
There is 3 more pieces of criteria to add in the search, but I cannot seem to get the answer from the first two in the function.
=IF(AND(MATCH("*City of Grand Rapids*",R6,0),IF(MATCH("*City of Grandville*",R6,0),"X")))
There is 3 more pieces of criteria to add in the search, but I cannot seem to get the answer from the first two in the function.