When you see the #VALUE error, it means that there is something wrong with the way the formula is typed, or there is something wrong with the cells you are referencing.

The zero value will replace the error. We hope this tutorial helps you understand how to remove the #NUM error in Excel; if you have questions about the tutorial, let us know in the comments.

Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible.

If you need to reconcile batches of records in Microsoft Excel, this simple VLOOKUP() solution offers a quick and easy way to find records in one batch that are missing from another.