Share via

Excel - error while trying to use a table for data validation

Anonymous
2020-01-28T04:10:48+00:00

I am having trouble creating a data validation list using a table as a source. The table is on a separate worksheet and has a name for the range of data.

In this case, the first sheet ("form") has three fields to be filled out, the third of which I want to have a drop-down referencing a table on another sheet ("admin") which has the heading and is named "consultants." I have followed the instructions on this tutorial: https://exceloffthegrid.com/using-an-excel-table-within-a-data-validation-list/ but still receive a "there's a problem with this formula" pop-up. 

I am able to use INDIFFERENT, but given the amount of data I intend to have I would prefer to use name ranges. Any suggestions?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-01-30T11:07:40+00:00

    Hi adoerkson，

    May I know you still need any help about this Excel issue? Please feel free to come back.

    Have a nice day!

    Best regards,

    Gloria

    Was this answer helpful?

    0 comments
  2. Lz365 38,201 Reputation points Volunteer Moderator
    2020-01-28T05:58:34+00:00

    Hi adoerkson

    My suggestion is to upload a sample of your workbook to any file sharing service (i.e. How To with OneDrive) and post the link in your next reply

    In your sample, somewhere, indicate where the drop-down list is expected and what's the data source (which Table + which column) for it

    Was this answer helpful?

    0 comments