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

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

On Sep 8, 9:52*pm, sharon wrote:
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