I am trying to search a cell for a tex phrase from another cell
Column A
21STC54
3DALU14
Column B
21STC53;SM|MOD|PORTAL;Accounts Payable;Accounts;Payable;21ST CENTURY BUILD LTD;UNIT 5 GAMMA;TODDINGTON;UK;GL54 5EB;;1;EN
21STC54;SM|MOD|PORTAL;Accounts Payable;Accounts;Payable;Alderwood Construction Ltd;Unit 5 Gamma;Toddington;UK;GL54 5EB;[email protected];1;EN
If colum A cell is in column b then True if not False
Bookmarks