I'm not sure if this is the correct forum. I am working in an Excel spreadsheet with two worksheets. One worksheet has the employee name, email, location, etc. The second worksheet has the manager's name and department that I need to populate into one spreadsheet. I need to have the software look up the employee name on sheet 1 and add a column that will match up and populate with the manager's name and location. Any help with the formula is greatly appreciated. Thank you in advance.
From United States, Atlanta
Acknowledge(0)
Amend(0)
From United States, Atlanta
Acknowledge(0)Amend(0)
What you need is a simple VLOOKUP formula. Try the one below and let me know if it gives you the output you need. Add the formula to the cell where you want the Manager's name to be printed.
Assuming the name of the employee in the current sheet is in column A, and the name of the employee in the other sheet is also in column A, with the manager's name in column B, use the following formula:
=VLOOKUP(*select cell A1 in the current sheet*, *select the range A-B in the other sheet*, 2, FALSE)
Note that the number 2 indicates that it will print what's in the column to the right of A. If the manager's name is in Column C, then select the range A-C and change the number from 2 to 3.
I hope this helps.
From India, Mumbai
Acknowledge(0)Amend(0)
9Assuming the name of the employee in the current sheet is in column A, and the name of the employee in the other sheet is also in column A, with the manager's name in column B, use the following formula:
=VLOOKUP(*select cell A1 in the current sheet*, *select the range A-B in the other sheet*, 2, FALSE)
Note that the number 2 indicates that it will print what's in the column to the right of A. If the manager's name is in Column C, then select the range A-C and change the number from 2 to 3.
I hope this helps.
From India, Mumbai
Acknowledge(0)Amend(0)
Allan has pointed it out rightly. However, if there are multiple criteria, then you need to replace the "Index & Match" function instead of using "VLOOKUP." It would be great if you could provide me with sample worksheets that align with your report expectations. Subsequently, I will demonstrate which function is applicable and explain the logic behind it.
To access various Excel-based reporting files, you may visit my blog site: [MIS Report formats - Manage your MIS Report](http://www.getmis.weebly.com).
Thank you.
Regards
From India, Kolkata
Acknowledge(0)Amend(0)
To access various Excel-based reporting files, you may visit my blog site: [MIS Report formats - Manage your MIS Report](http://www.getmis.weebly.com).
Thank you.
Regards
From India, Kolkata
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
10 ways to format Excel data.pdf
Payroll Data Format in Excel.xls