Two tables/two workbooks. Matching data in columns to add data to a third.

I have two different tables on two workbooks. Table 1, Workbook 1: Column 1 is names, Column 2, initials, Column 3 dates.

Table 2, Workbook 2: Column 1 initials, Column 2 dates.

There is more data on the tables that isn’t relevant to my question and not all names, initials, and dates are common to both tables.

Is there a way to match dates and initials on both tables (Columns 1 and 2) that will add the names to a Column 3 on Table 2, Workbook 2?

Right now I’m eyeballing dates and initials and cutting and pasting.