See http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Brablo" <gestureofrespect@yahoo.com> wrote in message
news:1145472846.745120.66690@i40g2000cwc.googlegroups.com...
> 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.
>