lundi 24 juin 2019

Using regexmatch to match part of a cell to values in a column to see there is a match

I have a column (Column A) of cells with tracking information. Each cell contains the date shipped and a tracking number. I have another column (Column B) with a bunch of tracking numbers. How can I see if the tracking number within column A matches any of the tracking numbers within column B?

This is what I have tried:

=IF(RegExMatch(A1, TO_TEXT(B:B)),"YES","NO") but that's not working

All of the results are coming back as "YES" even though there is no match. Any thoughts on this?

Aucun commentaire:

Enregistrer un commentaire