vlookup with dropdown list

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
 
J

JLatham

I think the best place to point you to for help on these dependent lists are
these two:
http://contextures.com/xlDataVal02.html
http://contextures.com/xlDataVal13.html

In setting up data validation, you can set it to lists that are on other
worksheets in a workbook if you give those lists Names. When you set up Data
Validation using the wizard, you choose List as the type of data and then in
the "Source" entry box you type something like
=ListRangeName
where ListRangeName is the name you gave to the list.

But it may be easier to simply put your lists on the same sheet in an unused
area and make sure that your PrintArea setting doesn't include that area.
 
V

vcff

Thanks JLatham

After going thru the sites provided, I manage to sort out and get the job
done.

Vcff
 
J

JLatham

Glad that I didn't point you to something that was totally a wasted effort on
your part. Hope you looked around on her site a little more - excellent
Excel resource.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top