Formulas Across/Within Sheets

Mollie.cleanvibes

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! 

Shaine Greenwood

Hello Mollie,

You might consider creating a lookup table in sheet 1 with all of the data that you want to have populated, then using the LOOKUP function to populate the data that you need based on the email address/name of the person. 

More information on LOOKUP can be found in the help center: https://help.smartsheet.com/function/lookup