Second cell in Data Validation
 

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

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

Second cell in Data Validation
 

Are you suggesting that I put that formula in the second cell?
--
Bill


"Bernie Deitrick" wrote:

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


.

Second cell in Data Validation
 

Yes.

Any cell but A2 or within the table range of D2:E100

Try entering Bernie's formula in B2


Gord Dibben MS Excel MVP

On Wed, 17 Feb 2010 14:57:02 -0800, WFariss wrote:

Are you suggesting that I put that formula in the second cell?