The INDEX function allows you to specify a list of nonadjacent ranges as the reference argument, and then specify which of these ranges to use in the area_num argument.

Name: The INDEX function allows you to specify a list of nonadjacent ranges as the reference argument, and then specify which of these ranges to use in the area_num argument.
Brand: Quizplus
Rating: 4.8 (29 reviews)

Question

Quizplus · Accepted Answer

The statement is true. The INDEX function can be used to specify multiple nonadjacent ranges and then select one of them using the area_num argument.

The INDEX Function Allows You to Specify a List of Nonadjacent