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