Lookup & Reference Archives - Page 3 of 3

Mar172020 by excelhelp131 Comment

INDEX Function In Excel

INDEX Function give result the value at a given position in a range or array. Index is used to get single values or entire rows and columns. Index function extract the specified row and column value from a table (database) available in excel. How to use : INDEX(reference, row_num, [column_num], [area_num]) <----(Optional) . reference:- Select the entire database from which you want to get the value. row num:- Then enter the row number from which you want to get the value. column_num : Then enter the column number from which you want to get the value. [area_num]) is (Optional) . Example shown in image below. FORMULA: =INDEX(B1:E5,3,4)

ROW Function In Excel

FORMULAS, Lookup & Reference

ROW function in excel is used to know the row number. It will give the the row number in according to the reference given. Example given below in image and video. FORMULA: =ROW(A2)

VLOOKUP In Excel

FORMULAS, Lookup & Reference

Vlookup is vertical' lookup built-in Excel function that work with array(data) that is available in excel columns. This function look-up or check the value in single column of database available in excel and returns the corresponding value from another column. The Image showing the exact example of it. PARAMETER : = VLOOKUP ( Lookup Value, Table array, Column Index, 0 or False (Exact Match) ) (more…)