INDEX

Returns the row index of a cell.
A11: =INDEX(A1:B2, 2, 2) => Pears
A12: =INDEX(A1:B2, 2, 1) => Bananas
A13: =INDEX({1,2;3,4}, 0, 2) => 2
A14: =INDEX(C1:C5, 5) => 8
A15: =INDEX(C1:D5, 5, 2) => 3
A16: =SUM(INDEX(C1:D5, 5, 0)) => 11