Excel: How do I create a cell that depends on a dropdown list selected item? -

Excel: How do I create a cell that depends on a dropdown list selected item? -

i have create simple user interface in excel 2003:

user selects client in drop downwards list , client adress cell should populated.

i have created list of customers on special workbook spreadsheet table like:

1 2 ======================= 1 customer1 address1 2 customer2 address2 3 customer3 address3

i have selected "customers column" (customer1, customer2, customer3) , created named list "customers". came user spreadsheet , placed dropdown list has values "customers" named list.

user can select customer1, customer2 or customer3 happily.

what shall add together workbook populate address cell automatically when user chooses client dropdown list ?

thank in advance!

you should create "address book" finish list in sample, perhaps on separate sheet (let's sheet2 example).

then add together in place of address1 (i think it's cell b1) next formula:

=iferror(vlookup(a1,sheet2!a:b,2,0),"address not found!")

here assume address book located in columns , b of sheet2. include error check missing addresses well.

excel excel-vba