Can Data Validation return a value to a second cell from an adjacent column
in the list as well as the first cell when validation criteria is set as list?
--
Bill