CHOOSE function

This function will return a value from a given list of values based on an index number.


CHOOSE(Index, Value1, Value2, Value3,…)

  • Index (required) – This is the index value for the item you want to return from the list. The index number refers to the order of the list. 1 will return the 1st item in the list, 2 will return the 2nd item in the list and so on.
  • Value1 (required) – This is the first item in the list.
  • Value2, Value3 etc… (optional) – These are the other items in the list.


In this example we get the weekday name based on a number from 1 to 7 and a list of the names. When a value outside the range of 1 to 7 is entered for the index number a #VALUE! error is returned. When a non integer value like 5.65 is entered for the index number, the function will interpret this as 5 and return “Friday”.



About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.


Subscribe for awesome Microsoft Excel videos 😃

Related Posts



Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃