Drop Down Menu AutoPopulate Contact Info?

C

Clay H

I have a template for filling out quotes and I was looking to create a drop
down menu with all of the names of customers that I regularly send out quotes
to (it's about 20 people). I have figured out how to make a drop down list
with a bunch of names but I would like it so that when I select a name from
the drop down menu, the customers contact info pops up on the quote under the
name. Is this even possible?

Thanks!
 
D

Dave Peterson

I'd build a table on a separate worksheet.

Put the customer names in column A and the rest of the contact stuff in B:E
(say).

Then if A1 contained the dropdown (data|validation???) for the names, you could
use this:

In A2:
=if(a1="","",vlookup(a1,sheet2!A:E,2,false)
In A3:
=if(a1="","",vlookup(a1,sheet2!A:E,3,false)
....

If you send that workbook to your customers, remember that you'll want to
convert these formulas to values and delete that table sheet.

(I wouldn't want to share customer x info with customer y.)
 

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

Dependent drop down dynamic range formula, off sheet. 7
Formatted cell column in drop down list 1
Drop Down Menu 7
Drop Down Menu Title 2
Using more than one list in a drop-down 2
Excel Drop Down/ Autopopulate 5
Date Range Drop Down Menu 1
customize drop-down box 1

Top