Drop down boxes and linking to db

[solaraxis]

I am attempting to create a purchase order form and I would like in the
ship to address to place a drop down box of all my suppliers. When the
user clicks on the drop down box, a list of suppliers will appear. The
user will then choose a supplier name and click on it. After clicking
on it, I would like the form to automatically display the address,
contact info. and other relevant information. I am lost as to how to
do this. Thank you.

Francis

 

[Dave Peterson]

You could use Data|Validation to show the list of suppliers.

See Debra Dalgleish's site for nice instructions with pictures:
http://www.contextures.com/xlDataVal01.html

You'd build a table (on another sheet) with the supplier's name in column A and
the addresses, other info in columns B, C, ...

Then you could use a =vlookup() formula to return the portion you want.

=if(a1="","",vlookup(a1,sheet2!$A:$E,3,false))

If A1 held the supplier's name.

And you wanted to return the 3rd column in that table (when it matches exactly