How to match some lines according to a criteria in Excel?

Hi,
I have an excel sheet which i am sending in the attachment.

In sheet 1 I have this:

Name       Group
James      A
Brian      B
Richard      D
Jake              C
Lora         B

In Sheet 2:

Name       Department
Jake              Dev
James      QE
Richard      Dev
Lora              QE
Brian      Dev

What I want to make in Sheet 1 is:

Name       Group     Department
James      A            QE
Brian      B            Dev
Richard      D            Dev
Jake              C            Dev
Lora         B            QE

This is just an example and the actual list is so long.

How can I make it diagrammatically in Excel?


Thanks,



 

Book2.xlsx
TolgarAsked:
Who is Participating?
 
Rory ArchibaldCommented:
In C2 on sheet1 enter:
=VLOOKUP(A2,Sheet2!A:B,2,FALSE)
and copy down.

HTH
Rory
0
 
TolgarAuthor Commented:
Thank you it worked. But now I cannot count how many Dev and QE are in the Department column by simply doing ctrl + F and finding all.

How can I count them?

Thanks,
0
 
Rory ArchibaldCommented:
You can use a formula like:
=countif(c:c,"Dev")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.