Returning a blank cell

[Marvo]

What can I add to the following formula to return nothing if there is nothing in the searched for cell please.
adding ,"" at the end of the formula inside the brackets didn't work.

=XLOOKUP(D6,Handicaps!$I$4:$I$72,Handicaps!$H$4:$H$72)

Many thanks

 

[RoryA]

A cell with a formula cannot be truly blank, so the best you can achieve is:

=XLOOKUP(D6,Handicaps!$I$4:$I$72,Handicaps!$H$4:$H$72,"")

What was wrong with that option?

 

[Alex Blakenburg]

Adding "" inside the brackets is giving the default return value if "not found".
If you are sure the formula will return text and not numbers (which includes dates) then

=XLOOKUP(D6,Handicaps!$I$4:$I$72,Handicaps!$H$4:$H$72) & ""

 

[RoryA]

Ah, looks like I misunderstood. Since you have 2021 you can use LET:

=LET(d,XLOOKUP(D6,Handicaps!$I$4:$I$72,Handicaps!$H$4:$H$72,""),if(d="","",d))

 

[Marvo]

That worked a treat. Thank you.