I'm not sure if this is the correct forum. I am working in an excel spread sheet with two worksheets. One worksheet has the employee name, email, location, etc. The second spreadsheet has the manager name and department that I need to populate into one spread sheet. I need to have the software look up the employee name on sheet 1 and look up add a column that will match up and populate wit the manager's name and location. Any help with the formula is greatly appreciated. Thank you in advance.