I am trying to create a formula that will look between 2 different sheets with the same data sets and return a non-shared column and provide the max value within the specified criteria.

For example:

SHEET 1

A B C D
Name Location Zip Phone Number

SHEET 2

A B C D E
Name Location Zip Phone Number Date

What I would like is as follows:

I am trying to create a formula that will compare columns A, B, C, D on SHEET 1 against the columns for A, B, C, D on SHEET 2. If it find a match for all 3 criterias, it will return the lowest value in Column E on SHEET 2, as there may be many instances of the same "Phone Number", but occured on a different date. I want to know what the first date the "call" occured on.

Can someone please assist with this? I've picked my brain for 2 days and I'm lost.