I am using Data Validation for a drop-down and I would like to use it in such
a way that when a user clicks on the drop-down, and selects a value, another
value is displayed. Perhaps I can use an If or Vlookup statement for this,
but I do not know how to do this. I have the data I need in two
columns...for example:
Column A Column B
Mike 115487
Dennis 554442

So, in the drop-down, Mike would be visible, but after the user selects Mike
the value 115487 is displayed. Any help would be appreciated. Thanks.

Hi,

Follow this URL " Excel -- Data Validation -- Create Dependent Lists"
http://www.contextures.com/xlDataVal02.html

Challa Prabhu

"Send Object Command - Two attachments" wrote:

I am using Data Validation for a drop-down and I would like to use it in such
a way that when a user clicks on the drop-down, and selects a value, another
value is displayed. Perhaps I can use an If or Vlookup statement for this,
but I do not know how to do this. I have the data I need in two
columns...for example:
Column A Column B
Mike 115487
Dennis 554442

So, in the drop-down, Mike would be visible, but after the user selects Mike
the value 115487 is displayed. Any help would be appreciated. Thanks.