Nesting an IF, Then statement

Step 1 – Create a list of your cities

Step 2 – Create a picklist using cells from above
·    Select a cell for your picklist (I used A8) and click Data > Validation > Settings
·    Allow: List
·    Source:  For my example, A1 through A4.  (click the Source field and drag down your list)
·    Click OK.  Now your list is available.

Step 3 – Select a cell to display your statement (I use  D8)

Step 4 – Copy and paste the following into that cell

=IF(A8=A1,"Dallas Address Here",IF(A8=A2,"Fort Smith Address Here",IF(A8=A3,"Atlanta Address Here",IF(A8=A4,"OKC Address Here",""))))

Now, when you select Dallas from the drop down box, an address will populate.

  

Note – You will need to tweak the formula by changing the names in parenthesis.  For example, “Fort Smith Address Here” becomes “212 Elm Street”.