Xlookup: How to Fix & Prevent the #Value Error

Microsoft Excel Tips and Tricks

In this video, learn how one solution can take care of both #VALUE! errors and Absolute Reference errors when working with XLOOKUP formulas.

Credit Excel Campus – Jon