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