In Excel, is there a way to compare sets of cells to another set of cells (like comparing key-value pairs)?

Column A and Column B as key-value pair #1
Column C and Column D as key-value pair #2

Compare Key-value pair #1 with Key-value pair #2

>Solution :

Is this what you mean?

If so, you simply type this kind of formula in the top most cell and drag it down all the way to your last value. Quick and dirty.

=IF(A2=C2,IF(B2=D2,TRUE,FALSE),FALSE)

Otherwise, here is another approach:

=IFERROR( IF(VLOOKUP(C2,A$2:B$999,2,FALSE)=D2,"match","no match"),"Not found")

CREDIT to AC who provided the second part of the answer in this post: https://stackoverflow.com/a/33303583/22876455