Lists & =if

igetafix

New Member
Joined
Oct 6, 2006
Messages
3
Hi

I am trying to "code" my data and have 2 lists in my spreadsheet

Level 1:
Roof
Cladding
Windows
etc

Level 2 relating to say Roof in Level 1:
Glazed Roof
Solid Roof
Felt Roof
etc

What I'm trying to achieve is to select say Roof from a dropdown list in column A, with column B then automaticly giving me that specific dropdown Level 2 list, for example:

Level 1: Roof (Column A)
Level 2: Dropdown list as per level 2 above

I have named the respective lists already, but cannot get the formula right so that level 2 items appear when I select a level 1 item

Pleeeeease heeeelp!!!!
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi, igetafix
Welcome to the Board !!!!!

you will have some research to do in the following: so take your time :)

take a look at this "famous" thread
(the link is already pointed to the "most relevant post")

http://www.mrexcel.com/board2/viewt...=0&postorder=asc&highlight=cascading&start=26

for a technique using comboboxes
http://www.mrexcel.com/board2/viewtopic.php?t=152281&start=5

see also this explanation
http://www.contextures.com/xlDataVal02.html

and
http://www.mrexcel.com/board2/viewtopic.php?t=15030&highlight=
feel free to send an email (no PM)
you'll get three files with examples

subject of email
cascading comboboxes

kind regards,
Erik

EDIT: here's another thread which is running currently on the same subject: so you might follow that one too
http://www.mrexcel.com/board2/viewtopic.php?t=236673
 

Forum statistics

Threads
1,136,419
Messages
5,675,724
Members
419,584
Latest member
mrh8rr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top