Need help writing an excel formula

I have 2 worksheets with similar data: 1 has check #'s that are uncashed and the other has all checks disbursed and the recipient's address.  What is the best way to extract the address data based o...