Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Help
Hi What I'm trying to do is when I enter a name into one cell the one next to it automatically enters something else. E.G. Enter someones name in A1 and A2 automaically enters their managers name. Their name and managers name will be in a list. Any help will be greatly recieved, been trying yo sort out and it making may head spin -- TheTone ------------------------------------------------------------------------ TheTone's Profile: http://www.excelforum.com/member.php...o&userid=30029 View this thread: http://www.excelforum.com/showthread...hreadid=497157 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Help
TheTone wrote:
Hi What I'm trying to do is when I enter a name into one cell the one next to it automatically enters something else. E.G. Enter someones name in A1 and A2 automaically enters their managers name. Their name and managers name will be in a list. Any help will be greatly recieved, been trying yo sort out and it making may head spin The Tone I suggest using VLOOKUP in the the adjacent column to look up the Manager's name. If you need help with VLOOKUP, either reply back or better: Start new thread dealing with your VLOOKUP needs. Texas Handly |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Help
Say that your datalist is on Sheet2, A1 to B25,
With the employees name in Column A, and the managers name in Column B. On Sheet1, enter the name to lookup in A1, and try this formula in B1: =VLOOKUP(A1,Sheet2!$A$1:$B$25,2,0) You can copy this formula down Column B, if you have a list of names to find in Column A. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "TheTone" wrote in message ... Hi What I'm trying to do is when I enter a name into one cell the one next to it automatically enters something else. E.G. Enter someones name in A1 and A2 automaically enters their managers name. Their name and managers name will be in a list. Any help will be greatly recieved, been trying yo sort out and it making may head spin -- TheTone ------------------------------------------------------------------------ TheTone's Profile: http://www.excelforum.com/member.php...o&userid=30029 View this thread: http://www.excelforum.com/showthread...hreadid=497157 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |