With Excel’s Choose function, you can create a list of items, then select which of those items you want the function to return. For example, if you have a list of ice cream flavors that’s chocolate, vanilla, and coffee and specify item #2, the function will return “vanilla”. About Bob: Bob Flisser has been a software trainer since the mid-1990s, specializing in the Microsoft and Adobe suites. He has written and recorded video courses for LinkedIn Learning, Pluralsight, Skillsoft, Tuts+, and others, and is the co-author of a dozen books of tips and shortcuts for Microsoft applications. He has also written magazine articles and training manuals and set up corporate training centers. Connect with Bob: Experts Exchange: LinkedIn: Learn more about Experts Exchange: Info: Try free for 7 days: #excelforbeginners #excelhacks #exceltutorials