INDEX + MATCH = The Power Combo You Need!

Описание: Learn how to combine INDEX + MATCH to create powerful lookups in Excel — faster, smarter, and more flexible than VLOOKUP!
In this​​ second Excel short, see how =INDEX(B2:B6,MATCH("Dana",A2:A6,0)) pulls data perfectly.

Keywords: INDEX MATCH Excel, Excel lookup formula, replace VLOOKUP, Excel tricks, Excel short video, Excel tutorial 20 seconds, Excel tips for beginners.