help_book.xlsx

this is actually a form I created using Google docs but I converted to excel to try and figure out which formula will give me the results I seek. the user will input data in the form and it will be output in the spreadsheet. If a user selects a job position I want their email from column E sheet 1 to be copied into the corresponding job description cell on open positions sheet. It works if they only select one job title but if they select more than one the formula returns nothing. I hope I have explained this well enough.Thanks in advance for helping.

Jason