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