{"id":1257,"date":"2018-07-02T17:22:24","date_gmt":"2018-07-02T17:22:24","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1257"},"modified":"2023-11-02T19:15:59","modified_gmt":"2023-11-02T19:15:59","slug":"choose","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/choose\/","title":{"rendered":"CHOOSE function"},"content":{"rendered":"\n
The CHOOSE function in Excel allows you to select an item from a list based on its position. It’s like choosing from a menu where you pick an item by its number.<\/p>\n\n\n\n
CHOOSE(index_num, value1, [value2], …)<\/strong><\/p>\n\n\n\n You can use the CHOOSE function to select an item from a list of values. Here’s how you can use it with some examples: Example 1: Selecting a Fruit<\/p>\n\n\n\n This formula will return “Banana” because it selects the second item in the list. Example 2: Choosing a Day of the Week<\/p>\n\n\n\n In this case, the formula will return “Thursday” as it picks the fourth day. You can use this function in various scenarios, like creating dynamic drop-down lists or making choices based on specific conditions.<\/p>\n","protected":false},"excerpt":{"rendered":" The CHOOSE function in Excel allows you to select an item from a list based on its position. It’s like choosing from a…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
index_num:<\/b><\/td> The position of the value you want to choose. It should be a number between 1 and 254.<\/td><\/tr> value1:<\/b><\/td> The first value or item you want to choose from.<\/td><\/tr> [value2]:<\/b><\/td> (Optional) The second value or item you want to choose from. You can include up to 253 more optional values.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
=CHOOSE(2, \"Apple\", \"Banana\", \"Cherry\", \"Date\")<\/code><\/pre>\n\n\n\n
=CHOOSE(4, \"Monday\", \"Tuesday\", \"Wednesday\", \"Thursday\", \"Friday\")<\/code><\/pre>\n\n\n\n