cell referencing from a Combo Box

[cjc]

I'm trying to make the result given in a combo box make data appear i
the cells (or text boxes) to the left and right of the combo box. Th
data being drawn from is a range of cells in a column that is part of
table with the same arrangement as the combo box/cell arrangement.
just want to be able to choose data from that table, and by choosin
one element in a row, have the rest of the row appear around it.

I've been trying to find a formula that will allow a cell to refer t
the result in the combo box, and give its result as the cell dat
adjacent to that given in the combo box, as the data is in the origina
table.

Make sense? Is it possible?

Thanks

 

[Pul Falla]

Try using VLOOKUP to bring back the values from the table
that the combo looks at.

HTH

Paul