Second cell in Data Validation

[WFariss]

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?

 

[Bernie Deitrick]

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]

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

 

[Gord Dibben]

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