Excel Data Validation List: Can It Show Two Columns?

How-to basics · Updated November 19, 2026

No. In Microsoft Excel for Microsoft 365 on Windows, an in-cell data validation dropdown displays one column of choices, not two side-by-side columns. To show useful details together, combine fields into one display label for the list; if you need a true two-column dropdown, use a different control, such as an ActiveX combo box in desktop Excel for Windows.

Why an Excel validation list shows one column

Data validation is designed to restrict what someone can enter in a cell. When you choose List as the validation type, Excel presents a simple dropdown of permitted values. Each choice is a single item: a text string, number, date, or other value represented in the list. The control does not provide column headers, separate display and return fields, or adjustable widths for multiple fields.

The list source can be a range of cells or a list typed into the Source box. A range can be arranged vertically or horizontally, but that does not turn the dropdown into a table. A source with two columns is not a reliable way to make Excel show two fields; the in-cell dropdown is still not a multi-column picker. If users need to distinguish options using two pieces of information, make those details part of one list entry or choose a different interface.

This distinction also explains why a validation list is not the same as a database lookup control. The dropdown helps a user select an allowed value, but it does not inherently store a hidden ID while displaying a separate name. You can create that behavior with helper cells and a lookup formula, but it takes a little workbook setup.

Best in-cell workaround: combine the fields

For most workbooks, the simplest solution is to build a helper column whose entries include both details. For example, a product list might show P-104 — Desk lamp and P-207 — Floor lamp. A location list could show NYC — New York and LON — London. The dropdown remains one column, but people can see enough information to choose the right item.

This approach works especially well when users need to identify a choice but do not need a polished, table-like interface. It also keeps the list easy to maintain: update the source data, and the helper labels can update with it. Use a consistent separator, such as an em dash or a colon, so the combined entries are easy to scan.

  • Include a code and a name when names may repeat, such as employee numbers alongside employee names.
  • Include a category and an item when users could confuse similar options, such as Hardware — Cable or Software — License.
  • Keep labels concise because a long combined string can be awkward to read in a narrow dropdown.
  • Choose a unique label if a later formula will use the selected text to find a corresponding record.

Build a two-detail dropdown with a helper column

Here is one way to create a list that displays a product ID and name together. Put product IDs in A2:A20 and product names in B2:B20. In C2, enter the following formula, then fill it down through C20:

With the product ID in A2 and the product name in B2, enter this in C2: =A2&" — "&B2. If A2 contains 104 and B2 contains Desk lamp, the formula returns 104 — Desk lamp.

To use those labels in a validation dropdown, select the cell or cells where users should make a choice. On Windows, go to Data > Data Tools > Data Validation. In the Settings tab, set Allow to List, and enter =$C$2:$C$20 in Source. Leave In-cell dropdown selected, then choose OK. The menu path is the same in current Excel for Mac, though the ribbon layout can vary by version. Excel for the web can use and edit many validation lists, but some list-source editing options differ from desktop Excel.

If you add products later, update the source range or use a named range that expands with your data. A fixed reference to C2:C20 will not include a new entry in C21 until the source is changed. For a workbook shared among people using different Excel versions, a named range or a carefully maintained table-based setup can be easier to manage than relying on newer formula features.

Return a separate ID after someone picks a label

A combined label is useful for selection, but another part of the workbook may need only the ID. Suppose the user selects a label in B25, product IDs are in A2:A20, and the matching combined labels are in C2:C20. Enter this formula in D25 to return the corresponding ID:

With the selected label in B25, IDs in A2:A20, and matching labels in C2:C20, use: =INDEX($A$2:$A$20,MATCH(B25,$C$2:$C$20,0)). If B25 contains 104 — Desk lamp, the formula returns 104.

This formula uses INDEX and MATCH, which are available in older Excel versions as well as Microsoft 365. MATCH looks for an exact match because its final argument is 0; INDEX returns the value from the same position in the ID range. Make sure every combined label is unique. If two records have identical labels, MATCH returns the first match, which could produce the wrong ID. Adding a unique code to each label prevents that ambiguity.

You can keep the helper column visible for easy auditing or place it on a separate worksheet and hide that sheet or column. Hiding is only a presentation choice, not a security measure: workbook users may still be able to reveal or inspect the data.

When a real two-column dropdown is needed

If the user must see two separate columns at once—for example, an employee name in one column and a department in another—an ActiveX combo box is one desktop Excel for Windows option. It is a worksheet control rather than an in-cell data validation dropdown. On the Developer tab, choose Insert > ActiveX Controls > Combo Box, draw the control, and use Developer > Design Mode to select it. Open its Properties and configure settings such as ListFillRange, ColumnCount, ColumnWidths, and LinkedCell.

For instance, ListFillRange can point to a two-column range, ColumnCount can be set to 2, and ColumnWidths can specify the width of each displayed column. The LinkedCell setting determines where the selection is recorded; BoundColumn controls which list column supplies the linked value. Check the control’s behavior in the workbook rather than assuming that the displayed text and stored value are the same.

ActiveX controls are not a drop-in replacement for validation. They sit on the worksheet, can take more space, and may be affected by organizational security settings. They are not supported in Excel for the web and are not a practical cross-platform solution for Mac users. If the file will be shared broadly, a combined label in a normal validation list is generally more portable and simpler to maintain.

Other options and their trade-offs

A Form Control combo box can be another Windows desktop option when you want a control on the sheet, but it does not provide the same two-column display capability as an ActiveX combo box. A searchable form, a user form built with VBA, or a separate selection sheet can offer more control over the experience, but each adds setup and maintenance. VBA macros also require users to work in a macro-enabled workbook and may be blocked by security policies.

For a simple list, compare the options by asking what the user needs to see and what the workbook needs to store:

  • Combined label in data validation: easiest to share and maintain; the two details appear as one string.
  • ActiveX combo box: can display multiple columns on Windows desktop Excel; less portable and more complex.
  • Separate lookup formula: keeps a selected label readable while returning a code or related value in another cell.
  • Custom form or VBA: can support a tailored selection experience but introduces macro, compatibility, and maintenance considerations.

For most routine spreadsheets, the first and third options work together: show an informative combined label in the dropdown, then use a formula to return the code the rest of the workbook needs.

Common problems and how to prevent them

The dropdown does not show new choices. Check the Source range. A fixed range such as C2:C20 will not automatically include entries added below it. Expand the reference or switch to a source that grows with the list.

Excel says the source evaluates to an error. Check that the referenced cells exist, the formula begins with an equals sign when appropriate, and the source range is on the same sheet or referenced through a valid named range. A direct reference to a list on another worksheet may need a named range rather than a simple cross-sheet reference in the Source box.

The combined labels are confusing or duplicated. Add a unique ID or category to the display text. Before relying on a lookup formula, check whether two rows produce exactly the same label. Otherwise, a lookup can return the first matching record without warning.

The list is hard to read. Shorten labels and use a consistent separator. Validation dropdowns do not offer independent column widths, so a long description may be clipped or require scrolling. If seeing complete fields is essential, use a form or a suitable combo box instead.

Users can type a value that is not in the list. In Data Validation, review the Error Alert settings and ensure the alert is enabled with a Stop style if invalid entries should be blocked. Validation is useful for data entry, but pasted data or other workbook operations can sometimes bypass expected restrictions; important data should also be checked through appropriate review or formulas.

Frequently Asked Questions

Can Excel data validation display two columns?
No. The in-cell validation dropdown is a single-column list. Combine the information into one label, or use an interface such as an ActiveX combo box in Excel for Windows if separate columns are essential.

Can I use a two-column range as the validation source?
A two-column range will not make the in-cell dropdown display two fields side by side. Use a one-dimensional list of combined labels for predictable results, especially in a workbook shared across Excel versions or platforms.

Can the dropdown show a name but store a different value?
Not by itself. A standard validation list returns the selected list entry to the cell. You can use a combined label and an INDEX/MATCH formula in another cell to retrieve a related ID or value.

Can I make the validation dropdown searchable?
The standard in-cell dropdown is not a full search-and-filter interface. Depending on the Excel version and how users interact with the cell, typing may help locate an entry, but it does not provide a searchable two-column picker. For a large catalog, consider a form or a purpose-built selection interface.

Will an ActiveX two-column combo box work in Excel for Mac or the web?
No. ActiveX controls are for desktop Excel on Windows and are not supported in Excel for the web or Mac. For cross-platform sharing, a combined-label validation list is usually the safer choice.

Related

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.