Reply to thread

Message: [QUOTE="vcff, post: 3223445"] 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 [/QUOTE]