linking drop down lists

  • Thread starter Thread starter reading2004
  • Start date Start date
R

reading2004

i have a new problem. i have a list of job titles in cell a2, these ar
all now in a drop down list that i have created. each job title has
seperate code number. how can i make it so that when i select a jo
title in the drop down list, tha the code number for that jo
automatically appears in the cell a1 next to it ??
 
Provided defined name "YourData" referrring to a range of cells containing
job title in first column and code number in second column:
=VLOOKUP(A2,YourData,2,FALSE)
HTH
Cordially
Pascal
 
Back
Top