Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Cells, What Formula do I use?
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Cells, What Formula do I use?
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Cells, What Formula do I use?
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. "John Bundy" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking cells again :-( | Excel Discussion (Misc queries) | |||
Linking cells from tab to tab | Excel Discussion (Misc queries) | |||
Linking cells into empty cells in another worksheet | Excel Discussion (Misc queries) | |||
Linking cells with a diffrent sheet with 2 cells | Excel Worksheet Functions | |||
Linking a horizontal set of cells to a vertical sets of cells | Charts and Charting in Excel |