Return blank if xlookup returns blank

[Rodney2485]

RIght now B11 is returning a result from a blank cell, what I want is for it to return blank if C11 is Blank

This is what i'm currently using =IFNA(XLOOKUP($C11,'File Dump'!D:D,'File Dump'!B:B),"")

E and F are also using the same forumla but I can fix that if I can fix the above issue.

Days Old	Pickticket	Wave #	Ship #	Ship Via	Customer Ship to
81	5000101664	20240112090		ONEN	BUMPER TO BUMPER CALGARY DC #12
54	5000101617	20240105003	0000960876	ONEN	MASLACK SUPPLY LTD-SUDBURY
27	5000101634	20240112133	0000974822	ONEN	AUTO PARTS CENTRAL WALL ST #1794
27	5000101716	20240106054	0000964405	ONEN	BENSON AUTOPARTS
26	7000251112	20231211100	0000920877	ONEN	Motorcade Industries Inc.
26	7000251120	20231219130	0000935742	ONEN	WEST-CAN AUTO PARTS (IMPERIAL)
25	7000251628	20231219137	0000935758	ONEN	CANUSA AUTOMOTIVE WARE
25	7000251627	20231219134	0000935752	ONEN	LORDCO DISTRIBUTION CENTER
25	7000251630	20231219135	0000935756	ONEN	LORDCO PARTS (HEAD OFFICE)
24	5000103080			ONEN	MOBILE PARTS INC.
24	7000257829	20231229194	0000951498	ONEN	MOTORCADE INDUSTRIES LIMITED
24	5000103080			ONEN	MOBILE PARTS INC.

[#2]

I've also tried
=XLOOKUP(C2&1,'File Dump'!D:D&--('File Dump'!B:B<>""),'File Dump'!B:B)

The Issue is there's a formula in the C column that seems to be the primary issue.

[#3]

@Rodney2485 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

[#4]

@HansVogelaar Here's a test file that has the same formulas and similar set of data.

[#5 · Accepted solution]

@Rodney2485 

Thanks!

=IF(C2="","",XLOOKUP(C2,'File Dump'!D:D,'File Dump'!B:B))