Can Anyone Tell Me How To Compare 2 Lists In Excel?

Asked By H. George 0 points N/A Posted on - 07/27/2016

I am working on making lists for my class, and through the lists I am comparing the names of students who scored more than 80% in grade 1 and then in grade 2. I want to award students who performed well in both. Can anyone tell me how to compare 2 lists in excel?

• Status: Open
• Question Views: 305
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Rubayyiat Quayyum 0 points N/A #117440

Can Anyone Tell Me How To Compare 2 Lists In Excel?

Yes, excel is an amazing tool for comparing lists.

Suppose you have two lists, list 1 which is A1 to A18, and list two is B1 to B15.

To find which are the names that exist in both, you can use a handy function called ‘Vlookup’.

You can use it in the syntax explained below:

VLOOKUP(, , , [range_lookup]) Remember that vlookup is short for vertical lookup. So, it moves vertically and checks all values.  

About Rubayyiat Quayyum

Questions
0

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/27/2016
• Question Category: MS Excel