Xlookup: How to Fix & Prevent the #Value Error Geraldine 2 years ago 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