I am running Excel 2003 and it looks like drop down lists only show 1 column.
could you do the application in Access, where you can show more than one
column then use the menu option to export to Excel for further analysis?

You can use a Visual Basic ComboBox for this. If you haven't already done
so, select View/Toolbars/Visual Basic from Excel's menu bar. Click on the
Control Toolbox icon from the Visual Basic tool bar (looks like a wrench and
hammer crossed over each other). This will add the Control Toolbar to the
spreadsheet's tool bars. From the Control Box, click on the ComboBox and
draw it onto your spreadsheet. If you are not already in Design Mode, select
the Design Mode icon from the Visual Basic tool bar (it's to the right of
the Control Toolbox icon). Once that is done, right click the ComboBox and
select Properties from the popup menu. Set the ColumnCount property to 2;
set the BoundColumn property to 2 (second of the two columns); set the
LinkedCell property to the cell you want to display your results in; and set
the ListFillRange to the 2-column range containing you list of bank names in
the first column and the account numbers in the second column. You can play
with the other properties if you want, but that is basically all you have to
do. Now, click the Design Mode icon on the Visual Basic toolbar to turn it
off. Click on the ComboBox and you should have a 2-column listing showing
your banks and account numbers. Select one and watch the cell you linked the
ComboBox to. One other thing, besides properties, that you might want to
play with is the Format Control option available when you right-click the
ComboBox in Design Mode.

Rick

You can do this with data validation and programming. There's a sample
file here:

  http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0005 - Data Validation "Columns"'