Formula - Drop Down Lists

[spicekid]

Any advice on a question I have.

I have a simple table that has data in it

Area (D2)
Title (D3)

For the above, D2 already has a formula that says =summary!L2, which is linking in from a previous tab which has a vlookup formula.

What I want D3 to show is a list of titles that are listed on another tab….so if D2 = pens, then D3 will show a list of titles only relevant to pens. If D2 = pencils, then D3 will show a list of titles only relevant to pencils.....there are about 40 areas that could be listed in D2 and there are about 200 titles in total.....

I hope I have made this clear....any advice would be greatly appreciated. I did try doing something around conditional drop down lists, but I don't know if this is the best way.

Alan

 

[Newport Count]

Hi,

Sounds like you need to use the INDIRECT function using drop-down options. You'll need to create a named range for all of the Areas to appear in D2 and then individual named ranges for each of the Titles to then appear in D3, based on the choice made in D2.

This site should guide you through it:
http://www.contextures.com/xlDataVal02.html


Cheers,
Rich