Matching across variables

[Hong_Hu]

Hi, I have a dataset with two phone numbers and I'd like to find records with matching phone numbers regardless if it's the first or the second. For example:

Record# Phone1 Phone2

1 123456789 111111111

2 222222222 123456789

I'd like to say record 1 and 2 is a match

What could you do to find that match? Thanks for any suggestion!

Best,

Hong

[binu_acs]

@Hong_Hu may be Find and Replace tool is an option

[Hong_Hu]

That's a great solution, thanks!

[Qiu · Accepted solution]

@Hong_Hu 
I would think a bit more complicated case though I am not sure whats your real data look like.

[Hong_Hu]

Wow Yes this is exactly what I need. Thanks!