Xlookup to with multiple conditions

[zinah]

Hi,

I use Xlookup to get the dates for my details tab. However, I need to refine the formula to get only today and any future dates, without getting old dates or even the dates that is formatted as 1/0/1900. Below is my sample data along with the formula that I'm using. Is there any suggestion to refine my formula to get the desired results?
Thanks!

Xlookup Help with dates criteria.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Current Result					Desired Results						IDs	Dates
2	IDs	Name	Dates			IDs	Name	Dates				AAA
3	AAA	John	10/3/2024			AAA	John	10/3/2024				BBB	3/3/2024
4	BBB	Will	9/3/2024			BBB	Will	9/3/2024				CCC	9/7/2024
5	CCC	Abbey	9/7/2024			CCC	Abbey	9/7/2024				DDD	########
6	DDD	Don	11/4/2021			HHH	Leo	5/1/2024				EEE
7	EEE	Louise	1/0/1900			NNN	Leon	3/8/2024				FFF
8	FFF	Sue	1/0/1900									GGG
9	GGG	Ron	1/0/1900									HHH	5/1/2024
10	HHH	Leo	5/1/2024									KKK
11	KKK	Frank	1/0/1900									OOO
12	OOO	Ronaldo	1/0/1900									NNN	3/8/2024
13	NNN	Leon	3/8/2024									BBB	9/3/2024
14	ZZZ	Shondha										AAA	########
15	LLL	Mona	1/0/1900									LLL
16
17
18
19
20
Details

Cell Formulas
Range	Formula
C3:C15	C3	=XLOOKUP(A3,$L:$L,$M:$M,"",,-1)

 

[Fluff]

Glad we could help & thanks for the feedback.