Compare row wise with Excel

1
votes

I have a requirement where I have 2 sheets. Now I have to compare the row wise records for each column of the excel. For Example:

First Sheet - Sheet1

enter image description here

Now in second sheet -Sheet2

enter image description here

Now for each row I need to check that the same row(Concatenated Value of PRODID & PRODCODE with Same value exist in the Sheet2 or not.

I have tried the same with below formula but the problem is it's matching with same row id of both the Sheets.

=IF(ISNA(VLOOKUP(CONCATENATE(A2,"-",B2),CHOOSE({1},CONCATENATE(Sheet2!A2,"-",Sheet2!B2)),1, FALSE)), "No", "Yes")

Please Help.

1
excelexcel-formulavlookup

1 Answers

1
votes

Use COUNTIFS()

=COUNTIFS(Sheet2!A:A,A2,Sheet2!B:B,B2)>0

enter image description here