vlookup with dropdown list

[vcff]

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

 

[Gary''s Student]

See:

http://www.contextures.com/xlDataVal02.html

 

[vcff]

Thanks for the help.

vcff

See:

http://www.contextures.com/xlDataVal02.html