INDEX and MATCH as alternative VLOOKUP in Excel
VLOOKUP is a very useful and powerful Excel formula. It has however, its limitations: for example, the searched word must be obligatory in the first column of the search matrix. This article provides an alternative to VLOOKUP. The alternative would…