hi everyone!

hope you're all well.

need your help with my macro-tool project. to give you an overview of my tool, this is actually a conflict of interest matching.
my tool should identify whether a farmer's declared relationship with an employee, is actually declared back by the employee.

for example:
Farmer A declares Employee A as his father.
Employee A declares Farmer A as his son.

in the above example, they are matched, because they declared both relationship.

I have 2 excel databases (FarmerDatabase.xlsx & EmployeeDatabase.xlsx).

what vba codes can I use to check whether my farmers declared those employees:
sample tables:

MACRO TOOL:

FARMER NAME DECLARED EMPLOYEE RELATIONSHIP
Abalos, Tito Abjelina, Ailyn Aunt
Abarra, Robert Abundo, Geronimo Emiliano Cousin-in-law
Zaragoza, Florence Zamora, Jocelyn Daughter-in-law
Hilario, Melvin Ongjuco, Rhon Stepson
Navasca, Lalie Agapinan, Claire Stepmother
Navasca, Lalie Alaman, Roger Brother-in-law

FARMER DATABASE:

EMPLOYEE NAME FARMER NAME Declared Relationship
Abjelina, Ailyn Abalos, Tito Cousin
Abundo, Geronimo Emiliano Abarra, Robert Grandfather
Zamora, Jocelyn Zaragoza, Florence Stepsibling
Ongjuco, Rhon Hilario, Melvin Stepson
Agapinan, Claire Navasca, Lalie Wife
Alaman, Roger Abendan, Liza Daughter
Alaman, Roger Navasca, Lalie Husband