Use the INDEX() function to retrieve the value of a particular cell within a matrix of cells.
Use the offset function to reference a cell or a group of cells in excel. The offset function itself isn't very helpful unless you combine this in application such as modelling straight line deprecation.
Search for values in a series of cells. The result is the position of the 'matched' value in the set.