Drop Down Lists

S

sam

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
 
T

Tom

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
 
T

Toppers

What is your formula?

DV should be:

Allow: List
Source: = A1:A10

Or

Source: =MyList where MyList is a named range
 
T

Toppers

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

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

sam

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

sam

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
 
Top