
MATCH Function In Excel
MATCH function is used to find a specified reference value position in a range of cells, and then returns the position of that reference value. Always remember that match function only take a single column or single row as a lookup array(range). Match parameter ( Lookup Value, Lookup array, 0 (For exact match) )
(1) FOR COLUMN DATA Example given below in image.
FORMULA COLUMN: =MATCH(B2,A2:A4,0)
(2) FOR ROW DATA Example given below in image.
FORMULA ROW: =MATCH(B2,B1:D1,0)