vlookup with dropdown list
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
|