Lookup- ChooseCell

Syntax:
=ChooseCell(Index, Selection)

Description:
Displays the value of a particular cell within a selection of cells.

Example:
Display the contents of the second cell (=G43) in the selection of cells: F43 to K43.
=ChooseCell(2,F43:K43)