Using dropbox selection to populate a cell from a separate sheet within a workbook.

Hey all, sorry to ask such a stupid question, but I cannot get the right thing to happen no matter what I try. Essentially, I want to select a name from a drop down list and have the merged cells below it return an address from a separate sheet in the same workbook. I have tried some different VLOOKUP functions, but I just cannot get them to work for the life of me. I have attached a link to a PDF with some photos of my spreadsheet (I created some templates so I could keep my actual clients anonymous), but the cells in the templates would be the cells in reference on my actual sheets. Any assistance would be greatly appreciated.

Edit: Since I cannot post anything in the main post with a link or photo, nor can I start with asking for help, I hope attempt number three works, and then I will try and respond with a link to a PDF of the spreadsheet in question.

Edit: I figured it out. Thanks everybody, sorry to waste your time because I am an idiot.