Allan Fernandes
Vp - Quikchex Hr And Payroll Software And
Karquin
Hr Coordinator
+1 Other

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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.
Hey Karquin
What you need is simple Vlookup formula:
Try the one below and let me know if it has the output you need. Add the formula in the cell where you want the Manager's name to be printed.
Say the name of the employee in the current sheet is in column A. The name of the employee in the other sheet is also in column A and the managers name is in column B.
=Vlookup(*select cell A1 in current sheet*, *select the range A-B in the other sheet*, 2, False)
Note that the number 2 means it's going to 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.
Hope this helps.

Hi Karquin,
Allan has pointed out it rightly. However if there is multiple criteria then you need to replace "Index & Match" function instead of using "Vlookup". It would be great if you give me the sample worksheets commensurate with your report expectation then accordingly I will show you the which function to be applicable and what's the logic behind it.
To get various excel based reporting file you may refer my blog site(MIS Report formats - Manage your MIS Report)

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™