Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup with dropdown list
I need to extract info from a dropdown list with reference to another cell
but cannot figure out how . A1 : with data vadilation to select from a range list named as "list" B1 : =IF(AI="","",VLOOKUP(A1,list,2,0)) C1 : =IF(AI="","",VLOOKUP(A1,list,3,0)) D1 : =IF(AI="","",VLOOKUP(A1,list,6,0)) E1 : in this cell, I need it to base on cell A1 selection and have a dropdown list (like data vadilation) to select from a data list under the name "area" F1 : in this cell, it will base on cell E1 selection and have a dropdown list to select from a data lsit under the name "location" Pls help (had only figure out to put the data in one worksheet by naming the data range and be used within the workbook vcff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup with dropdown list
See:
http://www.contextures.com/xlDataVal02.html -- Gary''s Student - gsnu200852 "vcff" wrote: I need to extract info from a dropdown list with reference to another cell but cannot figure out how . A1 : with data vadilation to select from a range list named as "list" B1 : =IF(AI="","",VLOOKUP(A1,list,2,0)) C1 : =IF(AI="","",VLOOKUP(A1,list,3,0)) D1 : =IF(AI="","",VLOOKUP(A1,list,6,0)) E1 : in this cell, I need it to base on cell A1 selection and have a dropdown list (like data vadilation) to select from a data list under the name "area" F1 : in this cell, it will base on cell E1 selection and have a dropdown list to select from a data lsit under the name "location" Pls help (had only figure out to put the data in one worksheet by naming the data range and be used within the workbook vcff |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup with dropdown list
Thanks for the help.
vcff "Gary''s Student" wrote: See: http://www.contextures.com/xlDataVal02.html -- Gary''s Student - gsnu200852 "vcff" wrote: I need to extract info from a dropdown list with reference to another cell but cannot figure out how . A1 : with data vadilation to select from a range list named as "list" B1 : =IF(AI="","",VLOOKUP(A1,list,2,0)) C1 : =IF(AI="","",VLOOKUP(A1,list,3,0)) D1 : =IF(AI="","",VLOOKUP(A1,list,6,0)) E1 : in this cell, I need it to base on cell A1 selection and have a dropdown list (like data vadilation) to select from a data list under the name "area" F1 : in this cell, it will base on cell E1 selection and have a dropdown list to select from a data lsit under the name "location" Pls help (had only figure out to put the data in one worksheet by naming the data range and be used within the workbook vcff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dropdown list determined by another dropdown list | Excel Discussion (Misc queries) | |||
HOW DO I CREATE A DROPDOWN PICK LIST FROM A VLOOKUP with multiple | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
VLOOKUP specific data for month required via dropdown list | Excel Worksheet Functions |