I am trying to construct a formula which would at least give me a TRUE or FALSE. I have two cells that each have a list of space-delimited text terms. I need to know if the second cell contains any of the text terms in the first cell. I need to do this for hundreds of rows of records, so it isn't a realistic option to have to transpose each cell into a column list. Also, the number of space-delimited terms is NOT constant. It varies from one record to another. So in the attached example, the formula would at least need to be able to return TRUE. If it could return a list of all matches, that would be icing on the cake, but I know that may not be possible outside of VBA, lol.