Data Validation
 

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

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



Select the A:B range on the customers sheet, excluding the header row.
Name the selection CUSTOMERS via the Name Box or via the option
Insert|Name|Define. And set CUSTOMERS (with Data|Sort) in ascending
order on the column of customer names.

Lets say that you want to data validate B2 on a different.

Select B2.
Activate Data|Validation.
Choose List for Allow.
Enter the following formula in the Source box:

=INDEX(CUSTOMERS,0,1)

Click OK.

In C2 enter:

=LOOKUP(B2,CUSTOMERS)

to fetch the address data of the customer, selected in B2.