What is the syntax for DROPDOWN in Excel?

The syntax for DROPDOWN is: =DROPDOWN(values, [default_value], [allow_null], [input_title], [input_message])

What are common errors with DROPDOWN?

Only available in Excel 365. Requires dynamic array support

How do I use the DROPDOWN function?

To use DROPDOWN, type =DROPDOWN( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

Why is DROPDOWN not working in my Excel?

Common issues with DROPDOWN include Only available in Excel 365; Requires dynamic array support. Start by checking the syntax =DROPDOWN(values, [default_value], [allow_null], [input_title], [input_message]), then verify each referenced cell or range.

Lookup & Reference

DROPDOWN Function in Excel

Creates a dropdown list in a cell allowing users to select from predefined options. This is an Excel 365 feature.

Syntax

=DROPDOWN(values, [default_value], [allow_null], [input_title], [input_message])

Arguments

values (required): Array or range of values for the dropdown list
default_value (optional): The default selected value
allow_null (optional): Whether to allow empty selection
input_title (optional): Title for the input message
input_message (optional): Message displayed when cell is selected

Examples

=DROPDOWN({"Yes","No","Maybe"}) - Simple dropdown with options - Result: Dropdown list
=DROPDOWN(A1:A5, A1) - Dropdown from range with default - Result: Dropdown list

When to use DROPDOWN

Use DROPDOWN when you need to retrieve values from a table or range based on a key.
Confirm data types match (text vs number) and trim spaces before lookups.
Pair with [IFERROR](/functions/iferror/) or [IFNA](/functions/ifna/) for cleaner reports.
See the [lookup functions guide](/guides/excel-lookup-functions-guide/) for VLOOKUP, XLOOKUP, and INDEX MATCH paths.

Common DROPDOWN mistakes

#N/A often means the key is missing or exact match is wrong — see [#N/A error](/errors/na/).
Lock table references with $ when copying formulas down a column.
Compare legacy vs modern lookups in [XLOOKUP vs VLOOKUP](/compare/xlookup-vs-vlookup/).

Common errors

Only available in Excel 365
Requires dynamic array support

Use cases

Data entry forms
User input validation
Interactive dashboards
Survey forms

Frequently asked questions

What is the DROPDOWN function in Excel? DROPDOWN creates a dropdown list in a cell allowing users to select from predefined options. This is an Excel 365 feature. The syntax is =DROPDOWN(values, [default_value], [allow_null], [input_title], [input_message]). Typical use cases include data entry forms, user input validation, interactive dashboards.
How do I use the DROPDOWN function? To use DROPDOWN, type =DROPDOWN( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
Why is DROPDOWN not working in my Excel? Common issues with DROPDOWN include Only available in Excel 365; Requires dynamic array support. Start by checking the syntax =DROPDOWN(values, [default_value], [allow_null], [input_title], [input_message]), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.