Link a Cell to a Dropdown List in Excel

In Excel for Microsoft 365 on Windows, create a dropdown with Data > Data Validation, choose List, and supply the list’s cell range. The selected value is stored in the dropdown cell; to show it in another cell, enter a reference such as =A2 in that second cell, assuming the dropdown is in A2.

What “link a cell to a dropdown” can mean

The phrase can describe two different Excel tasks. Most people want a cell to offer a dropdown and then want the chosen item available elsewhere in the workbook. With a standard data-validation dropdown, the dropdown cell itself holds the chosen text or number. A second cell can refer to it, and other formulas can use it.

There is also a separate control called a Combo Box in Excel’s Form Controls. It has an explicit Cell link setting, so it can write a selection result to a designated cell. That result is usually the item’s position in the input range, rather than the displayed item text. These are different tools, and the right choice depends on whether you need a simple in-cell list or a control placed on a worksheet.

For ordinary data entry, a Data Validation list is usually the simpler choice. It keeps the selection in the cell users are already editing, works naturally with tables and formulas, and does not require a separate control object.

Create a dropdown in a cell

First put the permitted choices in worksheet cells. For example, enter Open, In progress, and Complete in D2:D4. Then select the cell that should contain the dropdown, such as A2, and follow these steps:

Choose Data > Data Validation on the ribbon.
On the Settings tab, set Allow to List.
In Source, enter =$D$2:$D$4 if the list is on the same worksheet. You can also select the range with the dialog open.
Leave In-cell dropdown selected, then choose OK.

Select A2 and use the arrow that appears beside it to choose a value. The selected text appears in A2; the arrow is only the way to open the list. The validation rule does not create a second output cell or automatically copy the value to another location.

If you want users to be able to type values that are not in the list, review the Error Alert tab in the Data Validation dialog. Its settings control whether Excel shows a warning or blocks invalid entries. For a controlled status field, a blocking alert is often useful; for a flexible list where new values are acceptable, a warning or no alert may be more appropriate.

Show the selected value in another cell

A normal data-validation dropdown needs no special linking property. To mirror its current selection, enter a cell-reference formula in the destination cell. With the dropdown in A2, put this formula in B2:

With the dropdown selection in A2, enter this in B2: =A2. B2 displays the same selected value and updates when the selection in A2 changes.

A direct reference is usually enough, but there is a small display detail: when A2 is empty, Excel may display 0 in B2. If you prefer the destination to stay visibly blank until a choice is made, use this in B2 instead:

With the dropdown in A2 and the mirror cell in B2, enter: =IF(A2="","",A2). The formula returns a blank string while A2 is empty, and returns A2’s value after a selection.

Other formulas can refer to the dropdown cell directly, so a mirror cell is not required just to calculate with the choice. For example, a summary formula can test A2, or a lookup can use A2 as its search value. Keeping one authoritative input cell avoids confusion if someone later edits a copy instead of the original selection.

Keep the dropdown source list easy to maintain

A short, fixed list can live in a nearby range. For a list that will grow, placing the choices in an Excel table is more maintainable. Select the source data and choose Insert > Table, making sure the header option reflects whether the range has a heading. Give the table and its column clear names, such as Table1 and Status.

Data Validation’s Source box does not accept every structured table reference directly. A reliable approach is to create a defined name for the table column, then use that name as the validation source:

Open Formulas > Name Manager and choose New.
Name the range something simple, such as StatusChoices.
In Refers to, use the table column reference, for example =Table1[Status].
Set the dropdown’s Source to =StatusChoices.

As rows are added to the table, the named column reference expands with it, so the dropdown can use the new entries without manually changing a fixed endpoint. Avoid blank rows and duplicate choices in a source list when they could confuse users. Also remember that hiding the source worksheet is not the same as protecting the list from all changes; worksheet protection and workbook design should match how the file will be shared.

Build a dropdown that depends on another selection

A dependent dropdown changes its available choices based on a selection elsewhere. For example, a user might choose a department in B2 and then choose a role in C2. This is a different task from merely linking the selected value to another cell: it links the available options in one list to an earlier choice.

One established method uses a separate named range for each parent choice and a validation source based on the INDIRECT function. The names must match the parent selections, with spaces or punctuation handled consistently. In C2’s Data Validation Source, a reference such as =INDIRECT($B$2) asks Excel to use the name matching the value in B2. This method is workable for small, stable lists, but named ranges become harder to maintain as categories multiply.

For more complicated lists, consider organizing the source data as a table and using helper cells or a formula-driven list appropriate to the workbook’s Excel version. Microsoft 365 includes functions such as FILTER and UNIQUE that can help generate a changing set of choices, but data validation setup and compatibility should be checked in the actual workbook. Recipients using older Excel versions may not be able to calculate newer functions, so a simpler named-range design can be safer for shared files.

Decide what should happen when the parent selection changes. Excel does not necessarily erase a previous child selection just because it is no longer valid under the new parent choice. Users may need to reselect the dependent value, or the workbook may need a deliberate process to clear or flag an outdated entry.

When to use a Form Control Combo Box

Use a Form Control Combo Box when you specifically need a worksheet control with an explicit linked cell—for example, a compact selector on a dashboard. On Windows, enable the Developer tab if it is not visible, then choose Developer > Insert > Form Controls > Combo Box and draw the control. Right-click it and choose Format Control. On the Control tab, set the input range and the cell link.

The linked cell normally contains a number identifying the selected item’s position in the input range. If the input list is D2:D4 and the Combo Box’s linked cell is E2, a selection of the second item produces 2 in E2. To display the corresponding text elsewhere, use a lookup formula:

With choices in D2:D4 and the Combo Box’s position number in E2, enter this in F2: =INDEX($D$2:$D$4,E2). If E2 contains 2, F2 returns the second item, D3.

A Form Control is not the same as an in-cell validation list: it sits over the worksheet grid, can be moved or resized, and has its own properties. It can be useful for a dashboard, but it may be less convenient in a large data-entry table because users must interact with the control rather than simply select a cell. ActiveX controls are another category and have different compatibility considerations; they are not necessary for the basic task described here.

Common problems and practical checks

The arrow is missing: Select the cell and reopen Data Validation. Confirm that In-cell dropdown is checked and that Allow is set to List. Also check whether the worksheet is protected in a way that prevents editing.
The list does not include new choices: The Source may point to a fixed range that ends before the added rows. Use an expanding table-backed name or update the source range.
Excel rejects a source on another sheet: A direct cross-sheet range reference may not work in the Source box. Define a name for the source range and use the name, preceded by an equals sign.
The mirror cell shows 0: A direct reference to an empty cell can display zero. Use the IF formula above if a blank display is preferable.
The dropdown allows unexpected text: Review the Error Alert settings. The alert style determines whether invalid entries are stopped or merely accompanied by a message.
The list has duplicate or blank entries: Clean the source data, since duplicates can make the menu confusing and blanks can appear as empty options.

Validation is an input aid, not a guarantee that every value in a workbook is valid forever. Users can paste data into cells, and copied or imported content can bypass the normal selection process. If the choices matter for reporting, check the data separately—for example, with a review column or a formula that flags values not found in the approved list.

Excel desktop, Mac, and web differences

The steps above describe Excel for Microsoft 365 on Windows. Excel for Mac also provides data-validation lists through the Data tab, though dialog layout and ribbon presentation can differ. A standard in-cell dropdown and a formula reference are generally the most portable approach when a workbook will move between desktop platforms.

Excel for the web supports many common data-validation tasks, but some advanced editing and control features may be limited compared with the desktop application. Form Control Combo Boxes are desktop worksheet objects, so do not choose one if users need an equivalent interactive control in a browser. If a workbook will be edited across platforms, test the dropdown and any dependent-list logic in the environments recipients will actually use.

Frequently Asked Questions

Does a dropdown cell need a separate linked cell?
No. A Data Validation dropdown stores the selected value in the cell containing the dropdown. Reference that cell with a formula only if you want the value displayed elsewhere.

How do I link a dropdown selection to another cell in Excel?
If the dropdown is in A2, enter =A2 in the destination cell. Use =IF(A2="","",A2) if you want the destination to appear blank before a selection is made.

Can the dropdown list come from another worksheet?
Yes. A practical method is to define a name for the source range on the other sheet, then use that name in the Data Validation Source box. This avoids relying on a direct cross-sheet reference in the box.

What is the difference between a dropdown list and a Combo Box?
A Data Validation list is part of a cell and stores the selected item in that cell. A Form Control Combo Box is a separate worksheet object with an explicit linked cell, which usually stores the selected item’s position number.

Why does my linked cell show a number instead of the selected text?
If you used a Form Control Combo Box, its linked cell normally reports the item’s position in the input range. Use a formula such as INDEX with the input range and that position number to return the displayed text.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.