For example,

Sheet 1 is data base as below.
name group team
------ ------ ------
aaa red bear
bbb blue lion
ccc red lion
ddd yellow tiger
eee blue bear
.....

Now I want to fill up sheet 2 using sheet 1
name group team
------ ------- ------
ccc
eee
hhh

How can I find match group name and team name in sheet 1? What function is
working for searching. There is no duplicated name in data base.

Thanks.