how to compare multiple rows in excel sheets?-CodePudding

I have table values in sheet1

A1  B1      C1
Id  Name    Salary
100 James   1000
200 Nathan  2000    
300 Cook    4000
400 Lie     10000
500 umer    9899
600 barbi   2090

I have table values in sheet2

A1  B1      C1   
Id  Name    Salary
250 king    4000
100 James   1000
200 Nathan  2000    
300 Cook    4000
400 Lie     10000

I want to compare two sheets(1 and 2) and get the result in sheet3 like

A1  B1      C1
Id  Name    Salary
500 umer    9899
600 barbi   2090

CodePudding user response：

With ms365, try:

Formula in I1:

=VSTACK(A1:C1,FILTER(A2:C7,COUNTIF(F2:F6,B2:B7)=0))

Obviously ditch the VSTACK() if not available and just use the FILTER() part.