XLOOKUP when there are blanks in the data

I have an issue. I am using XLOOKUP (love it!!!!), and the fourth argument for the Errors works great. But if there is a BLANK in the data, then in this example for the number of customers, a 0 appears. I would like a "-" to appear, just like I have set for my errors. This works properly in my example for Net Sales and the Profit / Loss, which are in Accounting format rather than whole numbers.

Much of the data I work with includes blank cells, and I require a way to pull the data in, and suppress the 0s. There may be settings within Excel to change, however this is not an option, as these reports are sent to many people and done on a regular basis, so I cannot have all these people adjust their settings too.

I have attached a sample workbook, the salesmen is a dropdown, and the last 2 people in the table just joined the team in this example, and do not yet have active sales. Thanks in advance!

How about this?

=IFERROR(1/(1/XLOOKUP($H$3,sales[Sales Person],sales[No. Customers])),"-")

Please try

=LET(a,XLOOKUP($H$3,sales[Sales Person],sales[[No. Customers]:[Profit / Loss]]),TRANSPOSE(IF(a="","",a)))

or
=TRANSPOSE(IF(XLOOKUP($H$3,sales[Sales Person],sales[[No. Customers]:[Profit / Loss]])="","",XLOOKUP($H$3,sales[Sales Person],sales[[No. Customers]:[Profit / Loss]])))

AliGW,

Perfect!!!!! Thanks so much! With all the information available on XLOOKUP, and the 4th argument to avoid the dreaded IF statement, you would think this little gem would be included too. I am adding this to my notes, as I know I will need it again soon. Thanks again!

Bo_Ry,

I did not try your suggestion, as Ali's worked. But I wanted to thank you for your quick response to my problem.

Thanks for the rep.