Hello

I was wondering if anyone can help me populate my drop down list.

I have 2 columns. I want to populate my dropdown list with data from column a that has a specific value in column b.

is this possible with out using VBA?

eg.

Column A / Column B

123 / TEST
126 / TEST
100 / BACON
231 / CHEESE


basically I would like a drop down list that contains the constants from column b. so from the example above it should contain

123 and 126 as options.

Also can someone recommend a good tutorial book for excel?

Thanks

jonesyp