Check this link, it should answer everything for you
http://www.mrexcel.com/forum/showthread.php?p=126
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Ali Cat86" wrote:

Alright, I am trying to word this the best way possible so please bare with
me. I have a drop list that I have 33 options on. I want to know if there is
a way that if someone choses an option if it could populate another drop down
list by me imputting a formula. I have already used the IF function for
linking two colums and I don't know if I am just doing it wrong this time or
what. I know if I search long and hard I can find the answer, but I thought
asking couldn't hurt!