Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup using a dropdwn list, check different tables based on drop
Vlookup using a dropdown list, check different tables based on dropdown list
selection. Country Dropdown list, 10 different countries (for starts). Each country has a different course ID table. Each course ID table has approx 200+ courses. Each Course ID table has 2 columns; 1st is course ID, second is credit value for course ID. I set-up a country list with a numerical value (1st country =1, 2nd country =2, 3rd country =3, etc). I figured setting a numerical value would set me up for using IF function, coupled with vlookup. Course ID will be entered in A5:A45 (manually). I want value of course ID to appear in column C (C5:C45), based on country selected from dropdown, and course ID entered in A5:A45. -- Manny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list based on choice of another dropdown | Excel Discussion (Misc queries) | |||
count based on selection from drop down list | Excel Worksheet Functions | |||
Update Formula's based on drop down list value | Excel Worksheet Functions | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
Validation Tables For Drop Down list on a Separate Worksheet. | Excel Worksheet Functions |