View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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