Using functions in Excel makes working with spreadsheets million times easier, but the dark side of the functions are the errros. In this video we will fix the most common errors that might occur when using XLOOKUP formula in Excel. Enjoy!
FOLLOW ALONG! LINK WITH THE WORKBOOK:
https://www.dropbox.com/scl/fo/ftn3vi...
TIMESTAMPS:
00:00 Intro
00:24 Presenting the dataset
00:58 Fix #N/A
07:21 Fix #REF!
09:54 Fix #NAME?
12:03 Fix #VALUE!
16:03 Wrap up
RELATED VIDEOS:
Playlist with all my videos on Power Query: • Power Query