Need a formula to match two columns and another 2 columns to return a value

For the data I have to match up two names and two cities. If they match then they should return a value of the correct ID. The name, city, and ID that are being matched up to live in another sheet.

So, if Column A (sheet 1)= Column A(sheet 2) and Column B(sheet 1) = Column D(sheet 2) then they'll return the correct ID from column E in sheet 2.

Right now I have a formula two match the two names and return a value, but some of the names are repeats so I need a second match item to get the correct ID.

This is my current formula to match up just the names and return the ID.

=INDEX('Sheet 2'!B:B,MATCH(TRUE,EXACT(O6,'Sheet 2'!A:A),0))