formula help multiple if statements

this is the formula I started with. =if('Sheet1'!$K2="Treasure",'Sheet1'!$E2,"")
it works fine if only one response is given but with multiple responses I get no result.
Here is what I am trying to accomplish.

It's a form where a person can select multiple jobs to volunteer for.
I have a separate sheet to compile results and I would like to pull the email address given in sheet 1 to the corresponding column on page 2.

example:
enter email address in E2
choose all positions you are willing to perform....Treasure or Vault Guard or Dish washer or dish dryer etc..etc..

the results page would have a column header for each position and the email from E2 for every position selected by the user, they can make multiple selections.

thanks in advance.

definitely need a sample worksheet...

Ok how do I post a sample worksheet?

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

Did I upload the worksheet correctly?

[QUOTE



How user selects? Can I assume if a value appears in column K, it has been selected by user? Thanks.

>[/QUOTE]
yes that is correct. this is formulas that I am trying to use on a Google form and then download to excel to extrapolate the data I need.