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.
From United States, Atlanta
From United States, Atlanta
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.
From India, Mumbai
9What 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.
From India, Mumbai
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)
From India, Kolkata
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)
From India, Kolkata
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Advanced Excel 2003.pdf
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Email writing skills.part2.ho w to ask for information.ppt x