No Tags Found!

Dinesh Divekar

Business Mentor, Consultant And Trainer

Umakanthan53

Labour Law & Hr Consultant

Madhu.T.K

Seasoned Ir Professional

Vmlakshminarayanan

Sr.manager - Hr&admin

KK

KK!HR

Management Consultancy

Saswatabanerjee

Partner - Risk Management

Drsivaglobalhr

Doctor Siva Global Hr

Nanu1953

Ceo-usd Hr Solutions

AU

Aussiejohn

Workplace Assessment And Training

Rkn61

Sr. Hr Manager

NV

Nagarkar Vinayak L

Hr And Employee Relations Consultant

Alok-singh1

Labour Law & Ir.

NA

Nathrao

Insolvency N Gst Professional

Kumaracme

Hr Manager, A Leading Manufacturing Company

Srivastavacmlal

Master Consultant

Pan Singh Dangwal

Joint Manager

NK SUNDARAM

International Corporate Trainer / Hr (od) Consultant

R.N.Khola

Labour Laws & Ir

Bijay_majumdar

Freelancer In Hr &indirect Taxes For Services Indusrty.

Jeevarathnam

Sr Manager Hr & Compliances

Pvenu1953@gmail.com

Retired Government Servant/advocate

Ommygautam

Plant Hr Head

GL

Glidor

Hr Consultant

Loginmiraclelogistics

Asso.prof.(commerce & Management)

SU

Sudhapradheep

Sr. Executive-hr

Suresh2511

Labour Consultant

Ram K Navaratna

Hr Consultancy

KB

Kumari Boni

Hr Operations

PR

PratikShah043

Ass. Manager Qa

HA

Harshal

Hr Manager

WI

Wigglystylish

Turtle Co.

RG

Ravi Gali

Unemployed

BA

Basavaraju.audit@gmail.com

Auditor & Tax Consultant

AN

Angelajay

Accountant

RA

Ramp456

Accountant

SM

Shahid Mushtaq

Manager Admin

AP

Ambi_p

Head Administration


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
PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
Allan Fernandes
Vp - Quikchex Hr And Payroll Software And
Karquin
Hr Coordinator
+1 Other

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
If You Are Knowledgeable About Any Fact, Resource or Experience Related to This Topic and Want to Be Part of our support system - Please Register and Log In to CiteHR.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2023 CiteHRŽ

All Material Copyright And Trademarks in Posts Held By Respective Owners.
Members Notified Via CiteMailer.Com