Validation list question

N

newtechie

I have created 2 validation lists in two different cells - D & E. Cell D
contains the values 10A, 10B, and 10C. In cell E, the values are 1234,
1235, 1236. The cells are related in a sense that the first value in cell D
goes with the first value in cell E, and so forth. My question is: when I
select any of the values in D, how do I get the value to automatically input
in E?

Thanks in advance,
Newtechie
 
F

Frank Kabel

Hi newtechie

assuming that you have your validations list in a separate range (lets
say on a separate sheet called 'val_list') and they are ordered like
the following
A B
10A 1234
10B 1235
....

then you can simply use VLOOKUP to fill the cells in column E. Enter
the following in E1
=IF(D1="","",VLOOKUP(D1,'val_list'!$A$1:$B$10,2,0)

Frank
 
Top