help with IF function in combination with Search/OR function

[Zoe_83]

Hey all,

I have made a dropdownlist in column A with 4 different checklists (checklist_A, checklist_b, checklist_C, checklist_D). In Column B i made a dropdown list of de possible reasons. When you chose 'Checklist_C' in cell A2, then you should only get in cell B2 reasons starting with the letter C.1, C.2, C.3 etc. So when you chose 'Checklist_B', you should only get the the reasons beginning with 'B.1, B.2 etc).

Now the question: I am looking for a formula that looks at one specific cell, (say cell A2), with a certain value (say Checklist_C). And dependent on what is in the value in cell A2, i want to check whether cell B2 contains the text 'C.1' or 'C.2' or 'C.3' or 'C.4'. If not, then the value in C2 should come back with 'false' or something like that. So when in cell A2 'Checklist_D' is chosen, then the formula should check whether in B2 the text D.1 or D.2 etc is chosen.

Does somebody know how to do this? I added my excelsheet as an attachment. I tried something with the IF function and the OR function, but no results.

Thanks so much in advance.



A B C
Checklist Reason Check?
Checklist_C C.1 reason 1
Checklist_D D.2 reason 2
Checklist_B B.2 reason 2
Checklist_A
Checklist_B
Checklist_B B.3 reason 3
Checklist_D D.3 reason 3

[adyteo]

check this out
http://excelsemipro.com/2011/05/a-dy...list-in-excel/

[Zoe_83]

that's not exactly what i am looking for. I already made the dropdown list. Now i want to make a formula dependent what is chosen in that dropdownlist.

[adyteo]

if you read the whole thing you will see that it shows you how to dynamically allocate items to a dropdown, as you need for your file. you have created the dropdown lists in column A but you now need to allocate lists to column B that depend on the dropdown in column A.