Look at column and match and add this text te Solved/Closed

Question

Hello,
 I am working with Excel 2003. I need the formula to look in Column 1 and look at all these names. and compares the name if it is Sally the add Tom in column next to it ( this is who she reports to) , if first column second row is Mary and automatically add Julie on the same row she is but this specific column.

Example:
Name of employee              Reports to
       Sally                             Tom
       Mary                             Julie
       Bob                              Julie
       John                             Tom
so it looks at NameofEmployee column and it matches if it is this , this , this name then the manger is this and adds that name in the specif column.

Thank you
Brian b

mubashir aziz · Accepted Answer

Suppose in your sheet1 you have data of Employee Name & Manager of employee in column A & B 

   A     B  
emp    Manager
Sally    Tom
Mary    Julie
Bob     Julie
John     Tom 

Now in your sheet 2 you have only names in Column A 
A
emp name
Sally
Mary
Bob
John

Now in cell B2 of sheet2 write this formula and drag it down  ...

=INDEX(Sheet1!B:B,(MATCH(Sheet2!A2,Sheet1!A:A,0)))

Look at column and match and add this text te

1 response

Similar discussions

Subscribe To Our Newsletter!