Creating address envelop using drop down list

**aknsms** · 10-04-2015, 06:50 AM

Friends, I need some help

I am trying to create an envelop printing simple excel sheet. I have a format of envelop in Sheet1 and addresses in Sheet2.

In Sheet1 - E4 I have created a dropdown list of company names from Sheet2. I want to Fill the address area of Sheet1 (C5 to C9) with Name, Company, Add1, Add2, City, Zip and Phone when I select company name from drop down list.

Please help me. Thanks in advance. I am attaching the sample excel file.Envelope_sample.xlsx

**alansidman** · 10-04-2015, 07:37 AM

In C5: =INDEX(Sheet2!$B$2:$B$9,MATCH(Sheet1!E4,Sheet2!$C$2:$C$9,0))
In C6: =VLOOKUP(E4,Sheet2!$C$2:$H$9,1,FALSE)
In C7: =VLOOKUP(E4,Sheet2!$C$2:$H$9,2,0)
In C8: =VLOOKUP(E4,Sheet2!$C$2:$H$9,3,0)
In C9: =VLOOKUP(E4,Sheet2!$C$2:$H$9,4,0) & "," &VLOOKUP(Sheet1!E4,Sheet2!$C$2:$H$9,5,0)

**Czeslaw** · 10-04-2015, 07:52 AM

I offer this option.

Creating address envelop using drop down list

LinkBack

Thread Tools

Rate This Thread

Display

Creating address envelop using drop down list

Re: Creating address envelop using drop down list

Re: Creating address envelop using drop down list

Thread Information

Users Browsing this Thread

Similar Threads

Open Drop Down List and Date Picker with Target.Address

Excel 2007 : Drop Down Address List

Excel 2007 : Drop Down List Address

excel 2003: creating a standard email address from a list of names

[SOLVED] Creating a drop down list-How do I create this list and keep it hidden?

[SOLVED] Creating a drop down list from another drop down

[SOLVED] create drop down for address list

How do i insert a Address Bar kind of drop down list within MS Exc

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions