HELP! compare 2 cells then copy to next cell

Closed
dijae - Mar 15, 2012 at 11:03 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 20, 2012 at 10:39 AM
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
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Mar 20, 2012 at 10:39 AM
Hi Dijae,

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

Best regards,
Trowa
0