Hi,

You should already have a list of names and associated manager names in
another range for this. For eg, if you have this matrix in range A1 to
B10 and you type in the employee's name in cell C1, use this formula in D1

=VLOOKUP(C1,$A$1:$B$10,2,FALSE)

Regards

Govind.

TheTone wrote:

Hi

I've been told that this can be done using this fuctions. I want to be
able to type a name in says A1 and in A2 it returnes the managers name.
Then say another name in B2 and in B2 it returnes the manager name.

Any help will be welcomed.

Thanks