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

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!