Forum Discussion
Xlookup Formula return 0 but working
Hi! Me again. I have a working xlookup. L7 is text based (full name) input and works just fine. When I leave L7 blank then I get 0. How can I update the formula to return a blank cell when there...
Hi danhill365
What about?
=IF(ISBLANK(L7), ""
XLOOKUP(L7,'Emp.12.27 In'!D2:D14000,'Emp.12.27 In'!A2:A14000,"")
)
Would like to know the answer to this...I've checked and rechecked the formula. I'm not able to find out why in specific cells it returns "0" when in other cells with the exact same formula I can use the "If_not_found" function. It looks like a bug to me. I've only found a variety of workarounds on the internet, it would be nice to understand why it is occurring. Thanks!
Try
=LET(r, XLOOKUP(L7,'Emp.12.27 In'!D2:D14000,'Emp.12.27 In'!A2:A14000,""), IF(r="", "", r))
HansVogelaar Dank je wel Hans! Thank you Hans! Thanks to your suggestion, I have learned a very handy formula e.g. function.
