I have 2 worksheets one with summary data and other with full data. I need to return the earliest date in the full data set based on the following conditions:

Cell in summary data set = A

lookup full data set in 2nd worksheet that has the same value various times in Col A

then lookup the range that have the value A in Col A And check if col B is empty

then lookup range in Col C of the values that = tat of A and B and return earliest date.

Can anyone help?

Thanks