Excel Pro Trick: 2D Two way Lookup with Excel Intersection operator and INDIRECT Function in Excel

Learn how to perform two way or two dimensional lookup in Excel using INDIRECT function and intersection operator. This technique is unique in a way as we not using any LOOKUP function like VLOOKUP, XLOOKUP or INDEX/MATCH. Instead, we are relying on Excel's intersection operator!

In this Excel tutorial, we explore one lesser known way to lookup values in Excel table using operators. Excel has several operators including intersection operator represented by SPACE in formulas.

To lookup two-way i.e. along row and column simultaneously, we can use intersect with the help of INDIRECT function after making named ranges. Follow this tutorial step by step and learn this awesome technique!

Lets Excel!

Excel Workbook to Download or Practice online for this tutorial:
https://1drv.ms/x/s!Apno7889bCyLkB3P6hWC7u1oeTua?e=MclVfm

For more Excel tips, tricks and tutorials don't forget to subscribe to @LearnExceltoexcel channel.

Learn #Excel your way:
===================
Website: https://learnexceltoexcel.com/
--------------------------------------

Pick your favourite social page:

Fb: https://bit.ly/3yM3dvd
Tiktok: https://bit.ly/3wFllpf
Tw: https://bit.ly/3wGCRYU
Pin: https://bit.ly/3NsjKIU
Yt: https://bit.ly/3wxKL8a
Insta: https://bit.ly/3wtT9oW

Music by: https://youtube.com/ikson

#excelvlookup #vlookupformula #vlookupsum #exceltutorial #exceltips #twowaylookup #2dlookup #excel #lookup #lookupformula #lookupinexcel #lookupfunction #indirect #excelindirect #excellookup

two way lookup in exceltwo dimensional lookup in excel2d lookup in excel