Xlookup Formula return 0 but working

Copper Contributor

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

1 Reply

Hi @danhill365 

 

What about?

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