Excel beginner choose lookup functions

How to Use the Excel CHOOSE Function?

Choose Function for Lookup is a Excel function that returns a value from a list based on the index number provided in cell a1.. Formula Genius generates and validates this formula automatically from a plain-English prompt.

The CHOOSE function allows you to return different values based on a specified index number, making it perfect for lookup tables.

Generate This Formula Browse Library

The Formula

Prompt

"Return different text or values based on a number from 1 to 5 using a lookup table approach"

Excel 
=CHOOSE(A1, "Option 1", "Option 2", "Option 3", "Option 4", "Option 5")

This formula returns a value from a list based on the index number provided in cell A1.

Step-by-Step Breakdown

  1. Step 1: Identify the index number in cell A1.
  2. Step 2: List the possible return values in the CHOOSE function.
  3. Step 3: The function selects the value corresponding to the index number.
  4. Step 4: Ensure the index number is between 1 and 5 to avoid errors.

Edge Cases & Warnings

  • If A1 is less than 1, the formula will return an error.
  • If A1 is greater than 5, the formula will return an error.
  • If A1 is blank, the formula will return an error.
  • If A1 contains non-numeric data, the formula will return an error.

Examples

Prompt

"A1 = 3"

Excel 
Option 3
Prompt

"A1 = 1"

Excel 
Option 1

Frequently Asked Questions

What happens if the index is out of range?

The formula will return a #VALUE! error.

Can I use CHOOSE with more than 5 options?

Yes, CHOOSE can handle up to 254 options.

Is CHOOSE case-sensitive?

No, CHOOSE is not case-sensitive.

Can't find what you need?

Describe any formula in plain English and Formula Genius will generate, explain, and validate it — instantly.

Generate Custom Formula See Examples