2D Lookup INDEX and MATCH functions | Excel insta styl 20

Описание: In this short Excel tutorial, you'll see how to do a 2D Lookup using INDEX and MATCH functions. Excel insta style 20

How to do 2D Lookup with MATCH and INDEX function in Excel❓

1. We start with founding column number:
=MATCH(B8,B2:F2,0)
2. Then we have to found row number:
=MATCH(B9,A3:A6,0)
3. Now we can use INDEX function to find value we're looking for:
=INDEX(B3:F6,D9,D8)
4. At the end we can combine all functions:
=INDEKS(B3:F6;MATCH(B9,A3:A6,0);MATCH(B8,B2:F2,0))
5. Voilà... You did 2D lookup using INDEX and MATCH functions in Excel✨

👯‍♀️ Mark a friend who would also like this tip and follow for more tips!

Want to get 3 chapters of the Excel SuperHero book? Sing up: https://ExcelAndAdam.com/book

================
Files to download in the Eng folder on the website:
http://exceliadam.pl/youtube

You can also find me on:
📚Blog - https://excelandadam.com/
🍀Instagram -   / excelandadam  
🌟Tik Tok -   / excelandadam  
✨Facebook -   / excelandadam  
🕊Twitter -   / excelandadam  

#ExcelInstaStyle #ExcelAndAdam #excel