Перейти к содержимому

How to Do a Two Way Lookup in Excel Using INDEX and XMATCH Formula Tutorial

Endless Knowledge

0:00 / 0:00

How to Do a Two Way Lookup in Excel Using INDEX and XMATCH Formula Tutorial

12 096 просмотров · 1 год назад
Endless Knowledge
1,12 млн подписчиков
12 096 просмотров · 1 год назад
Learn how to perform a two-way lookup in Excel using INDEX and XMATCH for quick and accurate data search. This step-by-step tutorial shows you how to replace VLOOKUP with a more powerful formula. Perfect for mastering Excel lookup functions with practical examples. MS Office Foundation Course: https://endlessknowledge.graphy.com/c... Chapters: 0:00 Intro 1:27 Index Function 5:31 Xmatch Function 8:59 Index Xmatch One Way Lookup 16:17 Index Xmatch Two Way Lookup 21:53 Outro #excel #index #xmatch #exceltutorial #exceltraining #endlessknowledge