Japanese version. Functions related to cell address and value lookup. Functions. LOOKUP series functions. Find cells by value. Function Importance Description XLOOKUP High Get data matching the search value. VLOOKUP Middle Get the value of a specific column in the row matching the search value. HLOOKUP Low Get the value of a specific row of a column matching the search value. Other Search Functions. Function Importance Description INDEX Middle Get the values corresponding to the rows and columns of the specified range. MATCH Middle Get the relative position of the cell corresponding to the search value. OFFSET Middle Get the contents of a cell by specifying the distance from the … Continue reading Lookup & Reference(Microsoft Excel Functions)