wouter de jong
wouter de jong

Reputation: 597

How to match multiple rows of different columns in excel

I got an Excel like this:

---------
| 1 | a |
---------
| 2 | b |
---------
| 3 | c |
---------
| 4 | d |
---------
| 5 | e | 
---------

and a table like this:

---------
| 4 | d |
---------
| 3 | k |
---------
| 2 | b |
---------
| 1 | a |
---------

Now I want to check: If the data of the first column is the same in both tables, then check if the second column also has the same in that row. So of the example above, it would give a result like this:

---------------------
| 1 | a | correct   |
---------------------
| 2 | b | correct   |
---------------------
| 3 | c | wrong     |
---------------------
| 4 | d | correct   |
---------------------
| 5 | e | not found |
---------------------

Thanks in advance!

Upvotes: 0

Views: 584

Answers (1)

Scott Craner
Scott Craner

Reputation: 152505

Use this formula:

=IFERROR(IF(VLOOKUP(A1,F:G,2,FALSE)=B1,"Correct","Wrong"),"Not Found")

enter image description here

Upvotes: 1

Related Questions