Use selections from two data validation lists to lookup and return a mailing address

**lethonius2k** · 09-24-2013, 03:53 PM

Good afternoon all,

I'm back for additional assistance with my evolving workbook. Everyone has been very helpful.

This time, I am looking to add a Mailing Address field to the LOOKUP worksheet dashboard. Currently, when the user selects the State and County from the drop downs, the FIPS CODE populates. I'd like to have the mailing address for the selected county to also populate in the adjacent field.

The attached workbook illustrates what the resulting solution would look like (LOOKUP!F8:F11).

For example's sake, I have entered the mailing addresses of 6 county offices located in North Carolina on the NORTH CAROLINA-32 worksheet. Feel free to suggest how best to set up the location of the data (there will likely be upwards of 3700 addresses in the final product), either all addresses combined in one worksheet or separated by state on 50+ worksheets. Also, should the addresses be separated into three cells (as the illustration(LOOKUP!F8:F11) and (NORTH CAROLINA-32!E2:O5) are set up) or would it be best to house the entire address in one cell?

Thanks for any and all suggestions!

**FDibbins** · 09-25-2013, 01:30 AM

Take a look at the attached. In Master List, column B, you will need to add the full state names (and number) so that they match the sheet names (not sure if you want to remove the number from the sheet names, but that might make things simpler) I started with NC

Then on the NC sheet, I modified the layout a bit for the vlookup to pull in the postal address

on a side note, I have to say...that is 1 HECK of a mission you have there, good luck with it!!!!

If your sheets were all in the same sequence as the Master List column A, I have a quick method of extracting all sheet names - I tried it on your data but the sheet names dont line up with the states in A (line then up and we can do it easily)

**lethonius2k** · 09-25-2013, 08:45 AM

I like the sound of it, FDibbins. Can you please attach the workbook?

**FDibbins** · 09-27-2013, 12:14 AM

oops sorry about that, here it is...

**lethonius2k** · 09-27-2013, 09:25 AM

FDibbins,

This is beautiful! I'll go through and set up each worksheet as you suggested. Thanks for your assistance, kudos!!!

**FDibbins** · 09-27-2013, 12:42 PM

Happy to help and glad you like it so much

Thanks for the feedback and shout if you need more help

Use selections from two data validation lists to lookup and return a mailing address

LinkBack

Thread Tools

Rate This Thread

Display

Use selections from two data validation lists to lookup and return a mailing address

Re: Use selections from two data validation lists to lookup and return a mailing address

Re: Use selections from two data validation lists to lookup and return a mailing address

Re: Use selections from two data validation lists to lookup and return a mailing address

Re: Use selections from two data validation lists to lookup and return a mailing address

Re: Use selections from two data validation lists to lookup and return a mailing address

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Use selections from two data validation lists to lookup and return a combined result

Using Mutiple inputs from data validation lists to search sheet and return multiple record

[SOLVED] Lookup Based on multiple data validation lists

automatically synching selections from two validation lists

[SOLVED] address data base in which I can choose which to use for mailing

Bookmarks

Bookmarks

Posting Permissions