Formulas Across/Within Sheets

Building an employee hiring database (sheet 2) off our hired applicants sheet (Sheet 1). After typing an email address in the first column of the sheet 2 , it should populate 4 or 5 subsequent columns across the same row in sheet 2. The column information and email address are both included in sheet 1. I have tried many permutations of formulas, and can't find the right one. 


Suggestions? Thank you! 


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!