Lists & =if

[igetafix]

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!!!!

 

[erik.van.geit]

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

 

[Krishnakumar]

Also see Dependent Validation List

 

[igetafix]

Thanks Guys!