search a column knowing a cell

I wasn't sure how to write the title, but..

I have to columns of data, I want to be able to select a value from 1 column which will select the value from another column but on the same row.

I used a combo box for the 1st column, but don't know how to get it to take a value from another column.

Thanks

im not entirly sure what u mean with this??

do u mean u want the values from 2nd col to show in ur combo box??

or select them