Hello,

give a Name to the Sheet2!A1:A51, e.g. Statelist
Then on SHeet1 the required cell:
Data/Validation/lists and for the source: =Statelist

Voilá :-)

Best regards,
ANdras

"Brablo" wrote:

> Hello,
>
> How do I create a pulldown menu on sheet 1, in column A, which has a
> list of all 50 states in it? The states are listed in sheet 2 from
> cell A1:A51.
>
> I believe that this involves the vlookup command.
>
> Thanks in advance.
>
>