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.
Name of employee Reports to
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.