List Box or Combo Box selection to populate cells

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

Good day:

I have excel 2002 and I would like to have a list box or combo box to be
able to populate cells based on the selection. ie Choose company from drop
down .. will populate the address and phone number cells for that customer.
Not quite sure how to do this.. Just need some direction and I should be
able to figure it out from there. The name, address and phone number will be
on another worksheet. I figured I could put the whole name and address in
one cell and just make it big enough to fit once its dropped down.. but that
process is kind of clunky for someone else who may need to add more
customers later to those rows.

Any ideas/directions. Thanks in advance for your assistance.
 
Cheryl,

One solution might be to use VLOOKUP formulas in the various columns that
get the information about the customer. You're re-writing Access, sort of,
which does this effortlessly with related tables. With either solution, if
you update the information in your master customer file, this file will
update. The Cust Mast file will have to remain accessible for this to work
at all times.

To put static customer information from the Customer Master file based on
something like Customer Number will require a macro.
 
I'd look at Data|Validation (with the list of valid companies on another
sheet). This list would have the addresses and phone numbers in the adjacent
cells.

The use the =vlookup()'s to return the stuff you need:

=if(a1="","",vlookup(a1,sheet2!$a:$e,2,false))

would return the second column of that table.

Debra Dalgleish has lots of techniques for working with Data|validation at:
http://www.contextures.com/xlDataVal01.html
 
Back
Top