Course outline / Lookup functions
Lesson 30 of 75 · Intermediate · 3 exercises
Pick from a list with CHOOSE
Turn a number into one of several values with CHOOSE.
What you'll practise
- Name a quarter
- Name a weekday
- Turn a rating into words
Name a quarter
CHOOSE takes a number and returns that item from the list that follows. 1 picks the first item, 2 the second, and so on.
=CHOOSE(2, "Red", "Green", "Blue") gives Green.
In cell E2, turn the quarter number in A2 into "Q1", "Q2", "Q3" or "Q4".
Name a weekday
In cell E2, turn the number in B2 into a day name, where 1 is "Mon" and 5 is "Fri".
Turn a rating into words
In cell E2, turn the rating in C2 into "Poor", "Fair", "Good", "Very good" or "Excellent" for 1 to 5.
Try it in a real spreadsheet
Every step checks your answer instantly and tells you exactly what to fix.