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