I have been trying to figure this one out on my own and i can't seem to get it. I have a spreadsheet with names and i need to lookup email address for them and some have more than 1. I know there is a way but i just can't figure it out. Below is an example of my 2 worksheets and the end result i...