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.
Thank you Excelhelp for this funtion. Very useful for my daily office work