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 on if the check is in the uncashed column?

Any ideas/help would be great! I'm stuck!