You need to have an auxilary column which concatenates columns A & B. Then
make your drop down list columns C & D

Column a1 B1 C1 D1

Name ID # =A1 & " " & B1 Rate

"robert morris" wrote:


Is there a way (Excel 2007) to merge 2 columns with different info into one
Drop Down List?

Example:

Column a1 B1 C1

Name ID # Rate

As shown, A1 & B1 will not change. Column C1 can can change depending on
the task.

I just need to combine A1,B1 into one drop down list

Bob M.