Drop Down Lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
What is your formula?

DV should be:

Allow: List
Source: = A1:A10

Or

Source: =MyList where MyList is a named range
 
By "getting nothing" .... is the list blank?

As defined, I can't see why you get nothing if data exists in A1:A10
 
There is data in the list, but it returns no value. There is nothing unusual
about the data, it's just plain text....
 
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
 
Back
Top