Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381

Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381

Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381
Populating Information From One Excel Spreadsheet And Matching It Up With The Correct Info From The 2nd Spreadsheet - CiteHR

No Tags Found!

SH

Shai89308

Executive Hr

AS

Ammu Shanvi

Human Resource

GS

G SHASHI KRISHNA

Senior Manager - Hr

AH

Aizant HR

Human Resources

MA

MARSHAL

Safety Officer

AK

Anish Katoch

Hr Executive

PR

PranjalR

Hr Recruiter

AP

Alka Pal

Hr Executive

Karthikeyan8195

Management Consultant

MK

Mohit Kumar Puri

Head Marketing

AU

Austex

Accounts Manager


Karquin
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
Allan Fernandes
9

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
prodip_bata
15

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
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.




About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.