Data Validation - Dependent List
 

I have a spreadsheet where I need to set up Data Validation for a Dependent
list.

Sheet 1 - Validation List
Column A - Service
Column B - Price

Cell A1 value - Super NYC Show
Cell B1 value - $ 75

Is there any way I can set up Data Validation in Sheet 2 where if I selected
Selected Super NYC Show in Sheet 2, it will automatically pull up the
corresponding $ 75 value in the adjacent cell of the said spread sheet?

Prasad

Data Validation - Dependent List
 

It sounds like you want a lookup formula rather than a dependent DV list.

See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Prasad Gopinath" wrote in
message ...
I have a spreadsheet where I need to set up Data Validation for a
Dependent
list.

Sheet 1 - Validation List
Column A - Service
Column B - Price

Cell A1 value - Super NYC Show
Cell B1 value - $ 75

Is there any way I can set up Data Validation in Sheet 2 where if I
selected
Selected Super NYC Show in Sheet 2, it will automatically pull up the
corresponding $ 75 value in the adjacent cell of the said spread sheet?

Prasad