Data Validation - Dependent List

[Prasad Gopinath]

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

 

[T. Valko]

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

See if this helps:

http://contextures.com/xlFunctions02.html