search for data matching some condition

[Michael Hahn]

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.

 

[Jim Thomlinson]

You can use the Vlookup function. Something like this...

=vlookup(A2, Sheet1!$A$2:$C$10, 2, false)

 

[Michael Hahn]

Thank you very much!

I tested and it works.
You are the best.