Please Need an Example!

[TotallyConfused]

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]

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 here:

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