excel expert with data
 

I have a list of twenty English Course Descriptions in a drop down in A1.
When I select a specific English Course for the drop down list I want the
respective couse code # to appear in A2. Like this..........
A
1 English 9p
2 00032



I can create a drop down for course code #'s but would perfer Excel to
search and place the course code for me.

excel expert with data
 

Look at VLOOKUP in help.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"JVANWORTH" wrote in message
...
I have a list of twenty English Course Descriptions in a drop down in A1.
When I select a specific English Course for the drop down list I want the
respective couse code # to appear in A2. Like this..........
A
1 English 9p
2 00032



I can create a drop down for course code #'s but would perfer Excel to
search and place the course code for me.

excel expert with data
 

Set up the LOOKUP table then use VLOOKUP function


"JVANWORTH" wrote:

I have a list of twenty English Course Descriptions in a drop down in A1.
When I select a specific English Course for the drop down list I want the
respective couse code # to appear in A2. Like this..........
A
1 English 9p
2 00032



I can create a drop down for course code #'s but would perfer Excel to
search and place the course code for me.

excel expert with data
 

You can return a value to A2 using VLOOKUP formula to return the data
based upon selection from DV list.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

On Thu, 14 Jun 2007 14:56:00 -0700, JVANWORTH
wrote:

I have a list of twenty English Course Descriptions in a drop down in A1.
When I select a specific English Course for the drop down list I want the
respective couse code # to appear in A2. Like this..........
A
1 English 9p
2 00032



I can create a drop down for course code #'s but would perfer Excel to
search and place the course code for me.

excel expert with data
 

I tried...........I think I am too ignorant to work it out.
I'll give it a couple more shots

"Teethless mama" wrote:

Set up the LOOKUP table then use VLOOKUP function


"JVANWORTH" wrote:

I have a list of twenty English Course Descriptions in a drop down in A1.
When I select a specific English Course for the drop down list I want the
respective couse code # to appear in A2. Like this..........
A
1 English 9p
2 00032



I can create a drop down for course code #'s but would perfer Excel to
search and place the course code for me.

excel expert with data
 

I think I got it..............thanks for our help

"Teethless mama" wrote:

Set up the LOOKUP table then use VLOOKUP function


"JVANWORTH" wrote:

I have a list of twenty English Course Descriptions in a drop down in A1.
When I select a specific English Course for the drop down list I want the
respective couse code # to appear in A2. Like this..........
A
1 English 9p
2 00032



I can create a drop down for course code #'s but would perfer Excel to
search and place the course code for me.