XLOOKUP result for blank values is 0

microsoft-excel

Add &"" after the formula. For example:

XLOOKUP(C3,B6:B10,E6:E10)&""

(@Scott Craner's helpful comment formatted as an answer)

Related

How did BBSes allow multiple users to dial in at once?
No sound when changing volume
All files in my PC are stuck on "read only", even as the only admin
Cloned Samsung 970 Evo Plus NVMe SSD won't boot Windows
How to get exactly the same keyboard layout in Windows as in macOS?
Logitech mouse driver alternative for Mac OS X
SSL certificates for local web applications [closed]
How do I choose the download location in Microsoft Teams?
USB-C male to USB-A female data transfer: connecting a USB-C flash drive to a computer with a USB-A port
What does Terminal app's "Show Alternate Screen" do? (OS X)
How do you update an Excel file (Data Refresh and update formulas) WITHOUT opening the file?
How can you automatically run a script after connecting to a VPN on OS X?