index/match — Excel Tutorials/Discussions

Posts tagged index/match

Three (3) Reasons why INDEX/Match is better than VLOOKUP

Three (3) Reasons why INDEX/Match is better than VLOOKUP

Both are useful formulas, but one is simply the better choice.

Mario SalazarMay 2, 2020DataMighty, Excel, Data, learn, motivation, analyst, leadership, leader, development, leader development, vlookup, index, match, index/match, superior, better, which

VLOOKUP Tutorial

VLOOKUP is used to transfer data between to data-sets that have a common identifier.

Vlookup & INDEX/MatchMario SalazarApril 30, 2020vlookup, index/match, excel, tutorial, data, datamighty

INDEX/MATCH Tutorial

This formula is used as a reliable/efficient lookup function.

Vlookup & INDEX/MatchMario SalazarJuly 29, 2019vlookup, index/match, excel, tutorial, data, datamighty

IF Tutorial

The formula allows the user to test a specified scenario.

Mario SalazarJuly 25, 2019vlookup, index/match, excel, tutorial, data, datamighty

Search for a Word within a Cell

Used to identify whether or not a specific word is contained within a cell.

Mario SalazarJuly 24, 2019vlookup, index/match, excel, tutorial, data, datamighty