compare value across sheets and select the first value of a different column when the condition is m-CodePudding

I have two sheets the first is a data entry, the second creates a column of unique dates from the first sheet (this I have working). Next, I want to get the value in the first sheet where it matches the date in the second sheet. the problem is it returns multiple values and I only want the first for each date row matched.

here is a Google sheet example

Sheet2

CodePudding user response：

use:

=SORTN({Sheet1!A5:A, Sheet1!M5:M}, 9^9, 2, 1, 1)

9^9   return all rows
2     group by
1     first column
1     in ascending order