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
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