drop-down list

[rollorev]

This should be simple but it's not. I have created a worksheet with drop-down list boxes for much of the data input. There is a place I would like to use 2 columns in the data validation. ie....I would like the drop-down list for Client Name to post not only the client name column but also the client number as well. The name and number are in 2 different columns in a worksheet in the same workbook. We are using 2013.
Appreciate any help.

[Richard Buttrey]

Hi, and welcome to the forum.

The simplest way would be to concatenate the Client name & number into a single cell and use this concatenated column as the source for your drop down list box.

[rollorev]

This is going to work fine.
Thanks so much.