Xlookup: How to Fix & Prevent the #Value Error July 13, 2022 Noel Excel 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