★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Get the example file ★
Sign up for our free Insiders program and get the example file:
https://exceloffthegrid.com/insiders-signup/
File Reference for this video: 0237 SUPERXLOOKUP.zip
★ About this video ★
XLOOKUP doesn't spill vertically and horizontally at the same time. So why don't we build a custom function that does. It will do everything XLOOKUP can do, but more.
0:00 Introduction
0:31 What is SUPERXLOOKUP?
1:10 The problem
2:15 Handling errors
2:58 If not found
3:28 Horizontal fails
4:15 Adding variables
6:05 Horizontal lookup
7:30 Custom function
9:32 Testing
10:48 Using the function in other workbooks
11:15 Wrap-up
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: https://twitter.com/exceloffthegrid
#MsExcel