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)