How to do a two way lookup with INDEX and MATCH

preview_player
Показать описание
In this video, we use use MATCH to find the position of an item in a table, and we use INDEX to retrieve the value at that position. We work step-by-step so you can see how both functions work.
Рекомендации по теме