VLookUp Dropdown Function

[Syd]

I nees to build a drop down lookup on one sheet (2)
pulling values from sheet (1) column 1. How can I get that
done quickly?

Thanks,

 

[Bob Phillips]

Syd,

If you are using Data Validation, define a named range for the lookup table,
and use that in the DV definition.

 

[Syd]

Bob:

I'm new to this, how would I accomplish that task at hand.
I need a bit of hand holding.

Thanks,

 

[Debra Dalgleish]

There are some instructions here:

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