How to validate cell with "list" and added condition

A

AA Arens

I want to validate a cell with "List" and only when a neigboring cell
is filled it should start the combo:

In Cell E7: =IF(D7<>"",AVSIM,"")

With Insert > Name > Define I have made a data list AVSIM

But I get a error message:

"This list source must be a delimited list, a reference to single row a
colum"

How to solve this, because I don't see anyhing wrongdoing.

Bart
Ex 2003
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting: How to set condition "formula" with is "date"formatted 10
Define whether to use list 1 or 2 2
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
How to have one year value added to another cell 3
How to generate list of items with same status over three or moresuccessive days 2
copying a cell that has been formatted to cell with conditionals 1
Help to validate MULTIPLE numbers in one cell, not just the total 1

Top