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's no input in L7?
=XLOOKUP(L7,'Emp.12.27 In'!D2:D14000,'Emp.12.27 In'!A2:A14000,"")
Using Microsoft 365 Apps for enterprise