V
vcff
Need a dropdown list with reference to another cell
My problem
A1 : with data validation to select from a range named “list’
B1 : =IF(A1="","",VLOOKUP(A1,list,2,0))
C1 : =IF(A1="","",VLOOKUP(A1,list,3,0))
D1 : =IF(A1="","",VLOOKUP(A1,list,5,0))
E1 : in this cell, I need it to base on cell A1 and have a dropdown list fro
me to select from a range of data by the name “areaâ€
F1 : in this cell, I need it to base on cell E1 and have a dropdown list fro
me to select from a range of data by the name “locationâ€
Pls help
*I only able to figure out to give the data range a name in one worksheet
and will be able to be used in the whole workbook.
Regards
vcff
My problem
A1 : with data validation to select from a range named “list’
B1 : =IF(A1="","",VLOOKUP(A1,list,2,0))
C1 : =IF(A1="","",VLOOKUP(A1,list,3,0))
D1 : =IF(A1="","",VLOOKUP(A1,list,5,0))
E1 : in this cell, I need it to base on cell A1 and have a dropdown list fro
me to select from a range of data by the name “areaâ€
F1 : in this cell, I need it to base on cell E1 and have a dropdown list fro
me to select from a range of data by the name “locationâ€
Pls help
*I only able to figure out to give the data range a name in one worksheet
and will be able to be used in the whole workbook.
Regards
vcff