Formula to Sort Data in a new column from two different sets of data.

if, as sample implies, the dates are unique

Formula:

Please Login or Register  to view this content.

however, you could equally use Power Query - and if you have large datasets (and/or non-unique dates to handle) that would be more efficient.