indexmatch
INDEX MATCH is a combination of two functions in Microsoft Excel, INDEX and MATCH, that work together to allow users to look up specific information within a table or range of data.
The INDEX function returns the value of a cell within a specified range, based on the row and column numbers specified. It takes two arguments: the range of cells to search, and the row and column numbers of the cell to return.
The MATCH function returns the position of a specific value within a range of cells. It takes three arguments: the value to search for, the range of cells to search, and the type of match to perform (exact or approximate).
By combining these two functions, users can search for a specific value within a range of data and return the corresponding value in an adjacent column or row. This is particularly useful for large data sets where manual searching and filtering may be impractical
原文地址: https://www.cveoy.top/t/topic/dnRc 著作权归作者所有。请勿转载和采集!