Maybe data|validation???

Debra Dalgleish shows how to use dependent lists at:
http://www.contextures.com/xlDataVal02.html

Hi,

seperate each automaker out into a column and place at the top of the
column.  i.e. toyota goes in K1,Camry in K2,Corolla in k3 and on and on.  
According to the list you placed below, you would now have three columns side
by side.  Name each column by highlighting the column and go to
Insert>Name>Define.  

Use the forms menu to add a group box to your spreadsheet.  Now add an
option button foe each automaker to the group box.  Right click on each
button and select "Assign Macro".  In the macro code write the following:

Columns("E:E").Value = Range("nissan").Value

Where colum e is where you want to place the results of the search.  
"Nissan" is the column of values you want to select.

Repeat the macro for each button in the group box by double clicking.  Leave
the column as E or what ever column to add to, and change the range to equal
the selection.

Hope this helps...