Hello,
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
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