Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multilple linked Cells with Combo box
I have a listfill range of 4 columns by 15 rows. I want the first column of the listfill to be used for selecting from the combo box. What I want to happen is to have 3 fixed columns (linked cells) to be updated with the selection of the combo box. I can only get it to update the 1st cell of the 3. Anyhow have any ideas how to get all 3 linked cells to update? -- darken99 ------------------------------------------------------------------------ darken99's Profile: http://www.excelforum.com/member.php...o&userid=35055 View this thread: http://www.excelforum.com/showthread...hreadid=547982 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multilple linked Cells with Combo box
Have you tried linking the cells to each other in a chain? -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=547982 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multilple linked Cells with Combo box
If that first column consists of unique values, maybe you could use a few
=vlookup()'s to populate the other cells. If that linked cell is A1 (of sheet1) and the table is on sheet2 (A1:D15) =if(a1="","",vlookup(a1,sheet2!$a$1:$d$15,2,false) ) =if(a1="","",vlookup(a1,sheet2!$a$1:$d$15,3,false) ) =if(a1="","",vlookup(a1,sheet2!$a$1:$d$15,4,false) ) To return the other 3 columns. darken99 wrote: I have a listfill range of 4 columns by 15 rows. I want the first column of the listfill to be used for selecting from the combo box. What I want to happen is to have 3 fixed columns (linked cells) to be updated with the selection of the combo box. I can only get it to update the 1st cell of the 3. Anyhow have any ideas how to get all 3 linked cells to update? -- darken99 ------------------------------------------------------------------------ darken99's Profile: http://www.excelforum.com/member.php...o&userid=35055 View this thread: http://www.excelforum.com/showthread...hreadid=547982 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multilple linked Cells with Combo box
Right now I am only working with 1 sheet. I had tried using "IF" function but I was only able to input 10 options in the if statement. I thought there would be an easier way to link the output of 3 rows. I tried naming the linked cell as 3 columns but that didn't work either. Is there an option somewhere that lets you extend the linked cell from 1 to 3 cells? -- darken99 ------------------------------------------------------------------------ darken99's Profile: http://www.excelforum.com/member.php...o&userid=35055 View this thread: http://www.excelforum.com/showthread...hreadid=547982 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multilple linked Cells with Combo box
I ended up using INDEX/MATCH. It worked great. -- darken99 ------------------------------------------------------------------------ darken99's Profile: http://www.excelforum.com/member.php...o&userid=35055 View this thread: http://www.excelforum.com/showthread...hreadid=547982 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multilple linked Cells with Combo box
Well INDEX/MATCH doesn't work quite the way I had planned. I am not sure what is going on. The first 2 items on my combo box give me the right results in all 3 columns from my table. After that it starts returning random results in the 2 INDEX/MATCH columns. This is my code. =INDEX(U1:U100,MATCH(M56,T1:T100)) Where Column U = The cells I want to pick from to show up in code cell. Column T = The cells I am trying to match with M56 M56 = the cell I am trying to match (linked to combo box) Anyone know how to get it to pick from Column U to respective row in Column T? Thanks in advance. -- darken99 ------------------------------------------------------------------------ darken99's Profile: http://www.excelforum.com/member.php...o&userid=35055 View this thread: http://www.excelforum.com/showthread...hreadid=547982 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
0 in linked cells when watched | Excel Worksheet Functions | |||
How do I sort linked cells ? | Excel Discussion (Misc queries) | |||
quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
Preserving hyperlinks in linked cells | Excel Discussion (Misc queries) | |||
Update linked cells within a workbook??? | Links and Linking in Excel |