Returning a blank instead of a zero

[Marvo]

Good morning, if the following XLOOKUP formula results in a zero, how do I get it to return a blank please?

=XLOOKUP(A3,$R$3:$R$51,$P$3:$P$51,"",0)

I'm guessing adding an IF statement with a zero and "" but can't get it in the correct order.

Many thanks.

 

[bobsan42]

try this:

=LET(a,XLOOKUP(O11,Q12#,Q13:T13,"",0),IF(a=0,"",a))

 

[Marvo]

Lovely. Thank you.