Concatenate the cells in the next column and do the dropdown list off
that column.

Use something like this =A2& " "&B2& " "&C2 in cell D2 say.


--
PowerWheels
------------------------------------------------------------------------
PowerWheels's Profile: http://www.excelforum.com/member.php...o&userid=30045
View this thread: http://www.excelforum.com/showthread...hreadid=498600