Bottom Line: Learn the most common error with XLOOKUP and how to fix it. Skill Level: Beginner Watch the Tutorial Download the Excel File #VALUE! Error When working with XLOOKUP functions, there are two main errors that I've encountered, and both can be avoided using the same solution. Let's look first at the #VALUE! error. […]

Link to post: How to Fix & Prevent the #VALUE Error with XLOOKUP