Creating a list when the content of two columns match

I have two sets of data (A,B, then C,D).

Some of the content in column C and D does not appear in columns A and B:

A = reference numbers
00001, 00002, 00003, 00004

B = phone numbers for column a people
123456789, 234567890, 345678901, 456789012

C = reference numbers (these contain SOME of the reference numbers that appear in column A)
00001, 00002, 00004
(NOTE: 00003 is missing)

D = phone numbers for column C people (these contain SOME of the phone numbers that appear in column B)
123456789, 234567890, 456789012
(NOTE: the phone number 345678901 is missing)

I would like to create a separate column that contains the phone numbers (columns B and D) of anyone who's reference numbers appear in both columns A and C.

Please help.

Thank you.

Thank you.