Hi

I'm trying to create a dropdown list using the data validate keys. The
reference data is in the same worksheet, and the formula begins with an =.
However I get nothing once I've created this. Any suggestions?

Thanks in advance (again) for your help

First off, endure that you have NAMED your range. INSERT NAME DEFINE.
Ensure that the field where you define where the list is contains your list
that you want in the drop down.
Select the cell where you want the drop down list then select DATA
VALIDATION. Select LIST from the ALLOW menu, then type in "=YOUR_NAMED_RANGE"
into the SOURCE field.

Regards,
Tom


"sam" wrote:

Hi

I'm trying to create a dropdown list using the data validate keys. The
reference data is in the same worksheet, and the formula begins with an =.
However I get nothing once I've created this. Any suggestions?

Thanks in advance (again) for your help

What is your formula?

DV should be:

Allow: List
Source: = A1:A10

Or

Source: =MyList where MyList is a named range

"sam" wrote:

Hi

I'm trying to create a dropdown list using the data validate keys. The
reference data is in the same worksheet, and the formula begins with an =.
However I get nothing once I've created this. Any suggestions?

Thanks in advance (again) for your help

Hi,

It is:


Allow: List
Source: = $A$1:$A$10

Thanks,

"Toppers" wrote:

What is your formula?

DV should be:

Allow: List
Source: = A1:A10

Or

Source: =MyList where MyList is a named range

"sam" wrote:

Hi

I'm trying to create a dropdown list using the data validate keys. The
reference data is in the same worksheet, and the formula begins with an =.
However I get nothing once I've created this. Any suggestions?

Thanks in advance (again) for your help

By "getting nothing" .... is the list blank?

As defined, I can't see why you get nothing if data exists in A1:A10

"sam" wrote:

Hi,

It is:


Allow: List
Source: = $A$1:$A$10

Thanks,

"Toppers" wrote:

What is your formula?

DV should be:

Allow: List
Source: = A1:A10

Or

Source: =MyList where MyList is a named range

"sam" wrote:

Hi

I'm trying to create a dropdown list using the data validate keys. The
reference data is in the same worksheet, and the formula begins with an =.
However I get nothing once I've created this. Any suggestions?

Thanks in advance (again) for your help

There is data in the list, but it returns no value. There is nothing unusual
about the data, it's just plain text....

"Toppers" wrote:

By "getting nothing" .... is the list blank?

As defined, I can't see why you get nothing if data exists in A1:A10

"sam" wrote:

Hi,

It is:


Allow: List
Source: = $A$1:$A$10

Thanks,

"Toppers" wrote:

What is your formula?

DV should be:

Allow: List
Source: = A1:A10

Or

Source: =MyList where MyList is a named range

"sam" wrote:

Hi

I'm trying to create a dropdown list using the data validate keys. The
reference data is in the same worksheet, and the formula begins with an =.
However I get nothing once I've created this. Any suggestions?

Thanks in advance (again) for your help

Do want to send w/book?

toppers at REMOVETHISJohntopley.fsnet.co.uk

"sam" wrote:

There is data in the list, but it returns no value. There is nothing unusual
about the data, it's just plain text....

"Toppers" wrote:

By "getting nothing" .... is the list blank?

As defined, I can't see why you get nothing if data exists in A1:A10

"sam" wrote:

Hi,

It is:


Allow: List
Source: = $A$1:$A$10

Thanks,

"Toppers" wrote:

What is your formula?

DV should be:

Allow: List
Source: = A1:A10

Or

Source: =MyList where MyList is a named range

"sam" wrote:

Hi

I'm trying to create a dropdown list using the data validate keys. The
reference data is in the same worksheet, and the formula begins with an =.
However I get nothing once I've created this. Any suggestions?

Thanks in advance (again) for your help

Thanks Toppers,

I actually copied the data into a new worksheet and tried again and it
worked fine. I can only assume that since I've inherited this worksheet,
there must have been some layer of protection that I couldn't find.

I apreciate your help.
Cheers,
Sam

"Toppers" wrote:

Do want to send w/book?

toppers at REMOVETHISJohntopley.fsnet.co.uk

"sam" wrote:

There is data in the list, but it returns no value. There is nothing unusual
about the data, it's just plain text....

"Toppers" wrote:

By "getting nothing" .... is the list blank?

As defined, I can't see why you get nothing if data exists in A1:A10

"sam" wrote:

Hi,

It is:


Allow: List
Source: = $A$1:$A$10

Thanks,

"Toppers" wrote:

What is your formula?

DV should be:

Allow: List
Source: = A1:A10

Or

Source: =MyList where MyList is a named range

"sam" wrote:

Hi

I'm trying to create a dropdown list using the data validate keys. The
reference data is in the same worksheet, and the formula begins with an =.
However I get nothing once I've created this. Any suggestions?

Thanks in advance (again) for your help