Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What next to become a developer or excel expert | Excel Discussion (Misc queries) | |||
how to locate local excel expert | Excel Worksheet Functions | |||
Excel 2002 Expert Exam | Excel Discussion (Misc queries) | |||
Excel 2003 Expert Certification | Excel Discussion (Misc queries) | |||
Excel Expert Exam..! | Excel Discussion (Misc queries) |