function problem in excel

Discussion in 'Software Q&A' started by march27, Sep 20, 2006.

Thread Status:
Not open for further replies.
  1. march27

    march27 New Member

    Joined:
    Sep 20, 2006
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hello everybody...........

    I have database in an excel sheet having two columns the first col has names of the team members and the second column has name of team leader of that particular team to whom the team member belongs.


    My problem is that when I type a team member's name , I manuall have to search his/her team leader name from the roaster which has hundreds of records . I want that as I type a name in the excel sheet the corresponding cell should display its team leaders name. Can I do wiht the help of Excel inbuilt functions. I tried wiht DGET() function in category of DATABASE but i was failed.

    Can any one show me the way pleaseeeeeeeeeee.
     
  2. patkim

    patkim Active Member

    Joined:
    Mar 5, 2005
    Messages:
    804
    Likes Received:
    47
    Trophy Points:
    28
    Location:
    Mumbai,Pune
    try using VLOOKUP function..
     
Thread Status:
Not open for further replies.

Share This Page