I need an example of how to concatenate two column into one drop down box and
how to do a VLookup for a drop down box. Thank you.

If you mean a data validation dropdown, you can use a worksheet formula
to combine the values in two columns, then show the combined values in
the data validation list. There's an example on the following page:

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

Under Data Validation, look for "Data Validation Columns"

For VLookup, there's an example he

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


TotallyConfused wrote:
I need an example of how to concatenate two column into one drop down box and
how to do a VLookup for a drop down box. Thank you.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html