Xlookup Formula return 0 but working

[danhill365]

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

Best, 

DH

[#2]

Hi @danhill365 

What about?

=IF(ISBLANK(L7), ""
  XLOOKUP(L7,'Emp.12.27 In'!D2:D14000,'Emp.12.27 In'!A2:A14000,"")
)