DOUBLEXLOOKUP... the Excel function you've been waiting for!

★ 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-...
File Reference for this video: 0240 DOUBLELOOKUP.zip

★ About this video ★
Previously, we looked at the SUPERXLOOKUP function, which performed multiple one-way lookups and spilled the results. However, in many circumstances, we want a two-way lookup that spills the results. So... say hello to the DOUBLEXLOOKUP function.

During the video, we demonstrate how to build DOUBLEXLOOKUP from the ground up.

0:00 Introduction
0:37 Step 1 - Create the formula
3:07 Step 2 - Create DOUBLEXLOOKUP
8:25 Step 3 - Using DOUBLEXLOOKUP
11:36 Step 4 - Moving DOUBLEXLOOKUP
12:14 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:   / exceloffthegrid  

#MsExcel