Can anyone help me my issue?
I have probs that
i want get the a value base on id and earliest date whitin 2 multiple sheet.

please access below google sheet url
SUMMARY SHEET RESULT SHOULD BE LIKE COL A
ID TAG 1ST AMOUNT 1ST DATE
A 60,000 19/08/2024 23:49:57
B
C


DATA1
DATE IDTAG AMOUNT
19-08-2024 23:58:12 A 50,000
19-08-2024 23:54:15 B 600,000
19-08-2024 23:50:03 C 48,000

DATA2

DATE IDTAG AMOUNT
19/08/2024 23:49:57 A 60,000
19/08/2024 23:43:33 B 12,558
19/08/2024 23:41:58 C 70,000