Hi There

If I have understood you correctly, you are using a listbox from data
validation which looks at a list of customers, and you would like other
customer details displayed based on the customer you have in the list box.

If this is correct you can use a VLOOKUP to get the rest of the data on that
cusotmer

HTH

Peter
"gbeard" wrote:

I have a sheet of customers and their info. Column A is the customer name,
column B is their address and so on. I have a cell where I can select a
customer with data validation. I'd like the next column (beside the data
validation cell) to call the cell in column B next to the name of the
customer which is selected in the data validation cell, i.e. if the 10th
customer is selected in BF2 (the data validation cell), then the 10th
address would show in BG2.

Thanks in advance,
Gary