Linking Cells, What Formula do I use?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ali Cat86 - 28 May 2008 19:56 GMT

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!

Reply to this Message

John Bundy - 28 May 2008 20:24 GMT

Check this link, it should answer everything for you
http://www.mrexcel.com/forum/showthread.php?p=126

Signature

-John
Please rate when your question is answered to help us and others know what
is helpful.

> 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
[quoted text clipped - 3 lines]
> what. I know if I search long and hard I can find the answer, but I thought
> asking couldn't hurt!

Reply to this Message

Ali Cat86 - 30 May 2008 16:38 GMT

That was close to what I was looking for. However I have 33 items, 31 can
have the same drop down list but the other two cannot. Also, from the drop
down list of choices, I want to be able to have them click on one and another
list be populated. I have everything imputted, I just don't know what formula
is the right one to use.

> Check this link, it should answer everything for you
> http://www.mrexcel.com/forum/showthread.php?p=126
[quoted text clipped - 6 lines]
> > what. I know if I search long and hard I can find the answer, but I thought
> > asking couldn't hurt!

Reply to this Message