Returns an element from a list of choices based on index.
CHOOSE(index, choice1, [choice2, ...])
index- Which choice (of the up to 29 provided) to return.
indexis zero, negative, or greater than the number of choices provided, the
#NUM!error is returned.
choice1- A potential value to return. Required. May be a reference to a cell or an individual value.
choice2, ...- Additional values among which to choose.
OFFSET: Returns a range reference shifted a specified number of rows and columns from a starting cell reference.
index to return a value from the specified list of up to 30 values.
Andrew is a Docs and Sheets expert and author of this help page. Leave him feedback below about the page.