Need to check for new entries in the Data base and extract corresponding data

Hi all,

Plz help me in the following case. My project is stuck
Problem statement
Need to check for case numbers in my new data base and the corresponding version numbers( two different column comparison
) and see if it is a new entry( ie it is not repeating in my old data base). If it is a new entry I need it to extract the corresponding employee name from my new data base. PFA a sample scenario.

Jacc- Almost what i am ooking for. The challenge now is if the case numbers are same in both the excels( Old and new) it should confirm whether the version number is also same, then only it is a duplicate else it should be copied. for eg:-if the first case number "539480" is repeating in the old data base it should check whether the version number is also same in the old data base. If the version number is not "1" in old data base that case number an version number needs to be copied. Hope Im clear

Jacc- Please check the new attachments. I have populated the values which should be present in the non duplicate data base. and reduced the number of cases to three to keep it simple.

Just tweaked the formula u shared just now a bit- IFERROR(IF(VLOOKUP(B9,$F$7:$G$20,2,0)<>C9,B9,"-"),IFERROR(IF(B9<>F9:F22,B9,"-"),"-")). I hope this is correct