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.
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.
