NOT KNOWN FACTUAL STATEMENTS ABOUT COMMA-SEPARATED

you happen to be welcome. I think the problem will be the spaces for example There's " US1111" in mobile D2 and "US1111" in cell A22. this does not return a match due to foremost Room in mobile D2 which is just not in A22 (as part of your sheet). --====================================================================================================