MS-Excel (Lookup & Ref. Functions)

LOOKUP AND REFERENCE FUNCTIONS

ROW FUNCTION IN EXCEL
This function is used to return the selected row index number.
Syntax: =Row(E6)


ROWS FUNCTION IN EXCEL

This function is used to return the total number of selected rows.
Syntax: =Rows(A1:C6)


COLUMN FUNCTION IN EXCEL

This function is used to return the selected column index number.
Syntax: =Column(T5)

COLUMNS FUNCTION IN EXCEL
This function is used to return the selected column index number.

Syntax: =Column(B1:G6)

MATCH FUNCTION IN EXCEL
This function is used to find a particular value (Lookup_ value) in a given number list (Lookup_array)

HOME