Formula XLookup if target cell is not 0 nor empty

[Hermac]

Hello,
I'm looking for a formula like this one XLookup($C3;$C$4:$C$50;D$4:D$50) but if this leads to an empty cell or a cell with 0 I want a blank result (empty cell).
I know I could do it with an if-formula but that would be a very long one where the lookup chain $C3;$C$4:$C$50;D$4:D$50 would appear 3 times.
Would you have any better idea ?
Thank you very much
Herman

 

[Peter_SSs]

Try

LET(v,XLOOKUP($C3,$C$4:$C$50,D$4:D$50),IF(v=0,"",v))

 

[Hermac]

Try

LET(v,XLOOKUP($C3,$C$4:$C$50,D$4:D$50),IF(v=0,"",v))

 

[Hermac]

Thank you very much Peter. I was never aware of this Let function and it solves many of my other problems.
Have a beautiful day.
Heerman

 

[Peter_SSs]

You're welcome. thanks for the follow-up.

Let function ... solves many of my other problems

All the LET function does is allow you write shorter, more efficient, formulas. It doesn't actually allow or do any calculations that couldn't already be done with longer formulas.