Second cell in Data Validation
Bill,
Use a formula like
=IF(A2<"",VLOOKUP(A2,$D$2:$E$100,2,False),"")
where A2 has data validation based on the first column of your list in
$D$2:$E$100.
HTH,
Bernie
MS Excel MVP
"WFariss" wrote in message
...
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
|