Allan FernandesHey 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
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 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.