INDEX
Index function is a function in excel which gives the exact value in an array of data using the ROW NUMBER and the COLOUMN COLOUR
FORMULA
=INDEX(ARRAY,ROW_NUMBER,COLOUMN_NUMBER)
MATCH
MATCH FUNCTION is a function in excel which gives the relative position on an array of data using a specified order
FORMULA
=MATCH(LOOKUP_VALUE,LOOKUP_ARRAY,MATCH TYPE)
INDEX MATCH
THE INDEX MATCH function can be used together,as a flaeible and powerful tool for ectracting data from a table.it is the combination of two functions in excel which are INDEX AND MATCH FUCNTION……
FORMULA
=INDEX(ARRAY,MATCH(LOOKUP_VALUE,LOOKUP_ARRAY,MATCH TYPE),COLOUMN_NUMBER)
DATA VALIDATION
DATA VALIDATION is a feature in excel that allows you to control the data entered into the worksheet
