Populate cell based on value in other cell

[sholmb1]

I want to be able to populate cell B1 based on the value entered into cell A1. Cell A1 is a drop down list with values set up in a range on worksheet 2. Cell A1 is the associates name. I want cell B1 to be the associates manager.

On worksheet 2, in column A are all the associates names, in column B is the associates manager.

What I would like to happen is when I select a name (on worksheet 1) from the drop down list, the managers name would auto populate.

Thanks for any help.

 

[Tom Urtis]

It sounds like you might only need a VLOOKUP or INDEX MATCH formula in cell B1 of Sheet1.

VLOOKUP will probably do, but here's an INDEX MATCH suggestion, just because.

=INDEX(Sheet2!$A$1:Sheet2!$B$100,MATCH($A$1,Sheet2!$A$1:Sheet2!$A$100,0),2)

Modify for ranges and sheet names.

Is this what you are looking for, or is there something more to your situation?

 

[Nimrod]

Here you go mate... this seems to do it:

This formula assumes:
sheet1!A1 is where you put the name you want looked up the matching manager for
Sheet1!B1 is where the formula goes
Sheet2!A:A is where the employees names go
Sheet2!B:B is where the managers names go

=VLOOKUP(A1,Sheet2!A:B,2,FALSE)
This message was edited by Nimrod on 2002-05-17 23:12
This message was edited by nimrod on 2002-05-17 23:30

 

[sholmb1]

THANKS! The VLOOKUP works like a charm!