Japanese version. Although the VLOOKUP function is the standard way to perform searches in Excel, the INDEX and MATCH functions are superior in many ways. In this article, we will show you how to use a combination of the INDEX and MATCH functions instead of the VLOOKUP function This article will show you how to perform a search using a combination of the INDEX and MATCH functions instead of the VLOOKUP function.However, the XLOOKUP function was added in January 2020.This function is superior to the combination of the INDEX and MATCH functions, and its use is recommended in environments where the XLOOKUP function is available. Formula Enter the following formula. =INDEX(displayCellRange,MATCH(searchValue,searchCellRange,0)) … Continue reading Formulas that combine the INDEX and MATCH functions to perform searches better than the VLOOKUP function.(Microsoft Excel)