Populate Multiple cells when choosing one selection from drop down

  • Thread starter Thread starter MMANDIA
  • Start date Start date
M

MMANDIA

I have created a basic Work Order with drop downs, worls great. Now I would
like to add customers to a worksheet drop down. Once I select the customers
name, I would like to fill in address, Phone, Customer ID, etc. in work order
to print invoice.
I will put all this info into a worksheet in the workbook.
How can I do this in Excel.
 
Hi,

Create a table with all the info then use a VLOOKUP function to retrieve the
info, so if A1 is your drop down menu then.

=VLOOKUP($A$1,your table range,2,0)

the 2 in the formula represent the column number in the table, you can
replace it with either a COLUMN function or ROW function to make it easier to
copy across or down.
e.g.
=VLOOKUP($A$1,your table range,COLUMN(B1),0) ...copied across
=VLOOKUP($A$1,your table range,ROW(A2),0) ....copied down

B1 and A2 refers to the second column in the table.... don't forget to make
your table range aboslute ($B$1:$F$100) or you can name your table and use
that name in the forumula instead.

HTH
Jean-Guy
 
Jean, You just went way over my head... Can you show me a sample file...
Thanks for the quick response.
 
I would like to send you my file so you can see what I have.
Mike
 
Hi,

There's really no need, try this and if you can't get it working after then
you can send it to me!

just open a blank worksheet, in cells F1 to F4 type a few customer names, in
cells G1 to G4 type their phone numbers, in cells H1 to H4 their address...in
B1 type =VLOOKUP($A$1,$F$1:$G$4,ROW(A2),0) and copy down to B2, now type any
customer name from the table to see their info.

Regards!
Jean-Guy
([email protected])..remove dotcom
 
Jean, I will give this a try, If not you will see an email from me...

Thanks for all the help.
 
Jean, I email you a file yesterday... Hoping you received it. I would like
cell not to have to be in a cluster, as you see in CustID. that is my
misunderstanding.
Thanks again.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create Drop Down Box populated by a List 1
Select drop down menu option using libre-calc macro 0
drop down lists that populate other cells 2
Drop down list 1
Filtered drop down list 2
Expanded Drop Down Box Question 2
Best method to populate cell based upon drop down list selection 4
Drop Down Default 1

Back
Top