How to compare two sheets of data for matches?

[iamanexcelnoob]

hi all. curious what the best method for comparing two sheets of data.

essentially, i want to see which data in Sheet A turns up in Sheet B.

there are 3 columns (A,B,C) of data with matching parameters in both sheets that i would want to make sure align.

is an index/match formula the best to use in this instance? anything else? i tried conditional formatting and that didn't seem to work.

thanks all!

 

[DanteAmor]

One way is to concatenate each row in column D on both sheets, for example, in sheet A, in cell D2
= A2 & B2 & C2
and copy this formula down to the end of your data.

The same on sheet B.

Now, on sheet A in cell E2, you put this formula:

=MATCH(D2,SheetB!D:D,0)


And copy down.

 

[iamanexcelnoob]

One way is to concatenate each row in column D on both sheets, for example, in sheet A, in cell D2
= A2 & B2 & C2
and copy this formula down to the end of your data.

The same on sheet B.

Now, on sheet A in cell E2, you put this formula:

=MATCH(D2,SheetB!D:D,0)


And copy down.

awesome. let me give this a whirl!

 

[DanteAmor]

Ok, let me know if you have any questions.

 

[iamanexcelnoob]

One way is to concatenate each row in column D on both sheets, for example, in sheet A, in cell D2
= A2 & B2 & C2
and copy this formula down to the end of your data.

The same on sheet B.

Now, on sheet A in cell E2, you put this formula:

=MATCH(D2,SheetB!D:D,0)


And copy down.

this worked well, thank you!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.