Drop down list values dependant on value of another drop down list

I have a drop down box in column N, however I would like the options in that drop down box to change depending on what appears in column M.

If column M Says "Lapse" then I want one drop down box to appear in column N, If coumn M says "NTU" then I would like column N to show different drop down options.

I hope this makes sense, I am completely stumped by this and to be honest I don't think it is even possible??

Any advise would be greatly appreciated.

Thanks,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Name the range of cells you want as your Lapse list, Lapse and name the other NSU

This is accomplished by selecting a list then go to Insert|Name|Define and enter the name for the list... repeat for each list.

Then your data validation for the item in column N would be to select List and enter formula

=Indirect(M1) where M1 contains first drop down to be dependent on.

For more see here:

http://www.contextures.com/xlDataVal02.html

Hello,

place this Formula in your DATA VALIDATION (List) source box

=IF(C4="LAPSE",$M$9:$M$12,$N$9:$N$12)


C4 = cell containing LAPSE or NTU
M9 - M12 is your range of option for LAPSE and N9 - N9 is your range of options for NTU


Hope this helps

You have checked other responses above, right?

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Everything you need is explained in the link NBVC posted earlier.

http://www.contextures.com/xlDataVal02.html

Just go and read it and follow it. Replace the fruit and vegetables with Lapse and NTU and you're there.

See attached.

You need to fill the list in column D and the list in column F with the corresponding items you want to appear in column B when you select from the dropdown menus..