Multilple linked Cells with Combo box

D

darken99

I have a listfill range of 4 columns by 15 rows. I want the firs
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 b
updated with the selection of the combo box. I can only get it t
update the 1st cell of the 3.

Anyhow have any ideas how to get all 3 linked cells to update
 
D

Dave Peterson

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.
 
D

darken99

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?
 
D

darken99

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.
 
Top