Need a formula to display value from lookup table to worksheet
Posted by Dawn on July 24, 2001 7:20 AM
I have multiple financial worksheets that display a value (employee) but I need to determine who the mgr is. So, I have a lookup table of sorts that displays the employee in a column, the next column displays the manager.
How do I put together a formula in the worksheet to say look at the column that shows the employee (current worksheet), go look at the lookup table, determine the mgr and deposit that into the current worksheet.
Another issue, is that the employee (current worksheet) has a number after the name but it doesn't correspond with the lookup table.
Please help me...