Populate cell based on value in other cell

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Populate cell based on value in other cell

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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.

  2. #2
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,129
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  3. #3
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    THANKS! The VLOOKUP works like a charm!


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com