match-lookup-indirect

• Match function - is a function that searches a value in a list, and return its position.
• Syntax of Match:

  Match( value, Table_array, match_type )
• value - is the value to be search for in the table_array.
• table_array - is a range of cells that contains the value to be search.
• match_type - is optional. It the type of match that the function will perform.
• INDIRECT function - returns the reference to a cell based on its string      representation.
• Syntax of Indirect function: Indirect( string_reference, ref_style )