May be nothing wrong with your DV setup.

Could be that calculation is set to manual under ToolsOptionsCalculation.

BTW........when you say "lookup box" do you mean a cell with a vlookup formula
entered?


Gord Dibben MS Excel MVP

On Mon, 21 Jan 2008 09:44:01 -0800, Angel V.
wrote:

I've done what you said, but the value I get in the vlookup box is the same
all the way down, even tho I've changed the drop down selection. I'm sure
it's in my validation setup, but can't figure out what.

"Don" wrote:

Sounds like a combination of Data / Validation and Vlookup's? First , go to
the sheet with the values you want in the dropdown and select the range (like
A1:A25) , then in the uppper left corner that probly says A1, type over it
with the name you want like "LIST1". (I usualy highlight this so I know my
range) Then on the other sheet you want the dropdown in the cell, select the
range and do Data / validation and then do allow "List" and do "=LIST1".
Step one done.

Then in the next cell you can do a vlookup on what was selected from the
drop down to other values

"Angel V." wrote:

I have data on a worksheet, alphabetized by a certain column. On another
worksheet, I would like to be able to create a drop down list to choose one
of these values. then have that value, plus other values show up on the
worksheet.

Can this be done?