HELP! compare 2 cells then copy to next cell

[Closed]
Report
-
Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
-
Hello,

I need help copying the names from the master cell (A), if the other cell's (B) given names exist from the master cell, then copy to next cell (C).
Example:

-----A-----------------B-----------------------C
1--AAA, BBB--------AAA---------------AAA, BBB
2--CCC, ABA--------AAB CAA---------CAA, CCA
3--AAC, ABB--------CCC---------------CCC, ABA
4--CAA, CCA

A is the master record
B is the search names
C is the result copied

I hope you get my point.

Thank you in advance,
Dijae

1 reply

Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
484
Hi Dijae,

You mean somthing like this:
=IF(ISERROR(SEARCH(B1;A1));"";A1)

Best regards,
Trowa