linking drop down lists

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 ??
 
P

papou

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop-down list and error message 1
Chart Title change with Drop Down Selection 2
Data Validation and drop-down list using IF, AND and what else? 8
data validation list 17
drop down list 1
Drop Down List 2
Turning on data validation in one cell based on the contents ofanother cell 1
Code to hide rows if cell in another WS is ="No" 11

Top