Match two cells (from two columns) to two cells (in two different columns), then copy a cell (from a 5th column) into another cell (6th column)

I've read many questions here for over an hour and haven't quite found what I need, but it seems I will need either a LOOKUP, MATCH, or SUMPRODUCT. Here goes:

Columns A, B, C are my master list. Columns D, E would be a new/different list each week that would include some smaller list of songs that will appear in the master list. I need to match D&E cells to B&C cells, then copy the A into F. So, in this example, the outcome would be F2 ending up with the value of A4.

This is my first post here. I hope I've provided enough information to help you help me. I greatly appreciate your time.