Vlookup v. drop down box for mailing addresses


S

sharon

I am trying to incorporate a list of mailing addresses into an invoicevia
either a drop down box or Vlookup function (prefer the drop down box). What
I'd like to do is have a drop down list (I have approximately 100 vendors,
some are the same company name with multiple addresses) from which I can
select the vendor info.
I created and named a list on a separate worksheet within the document, but
don't know how to populate the address, city, state and zip fields into the
next row. The data list (on sheet2) looks like this (and named this range
"TO:"):
.........a..............b.......................c.....................d
1 ....ABC......123 Elm St.........Here, GA...........12345
2 ....DEF......456 Pine Dr........There, TX..........67890

I want the data to appear on the invoice (on sheet1) as:
.........a..............b.......................c.....................d
1...TO..............[DROP DOWN BOX TO CHOOSE VENDOR NAME]
2.....................[POPULATE CORRESPONDING ADDR (col b from data list
from b1)]
3.....................[CITY, STATE, ZIP (cols c and d of data list from b1)

Is this possible?

--Sharon
 
Ad

Advertisements

P

Pete_UK

You use VLOOKUP in conjunction with the drop-down - it's not really a
case of one or the other.

Put this formula in B2 of the Invoice sheet:

=IF(B1="","",VLOOKUP(B1,Sheet2!A:B,2,0))

and put this in B3:

=IF(B1="","",VLOOKUP(B1,Sheet2!A:C,3,0)&", "&VLOOKUP(B1,Sheet2!A:D,
4,0))

Hope this helps.

Pete
 

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

Top