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

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #117440

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

qa-featured

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.  

Related Questions