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.
Sat May 18, 2002 1:58 am
Tom Urtis MrExcel MVP
Joined: 11 Feb 2002
Location: San Francisco / Silicon Valley, California USA
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.
Is this what you are looking for, or is there something more to your situation?
_________________ Tom Urtis
Sat May 18, 2002 2:51 am
Nimrod MrExcel MVP
Joined: 30 Apr 2002
Location: Vancouver BC , Canada
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
[ This Message was edited by: Nimrod on 2002-05-17 23:12 ]
[ This Message was edited by: nimrod on 2002-05-17 23:30 ]
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the
Excel is a registered trademark of the Microsoft Corporation. MrExcel is a registered trademark of Tickling Keys, Inc.