Excel Lookup from different sheet

How to validate Flag Column in Sheet1 from Sheet2

Match if wrpt to ID CountryName from Sheet1 is matching in Sheet2

NoMatch if wrpt to ID CountryName is not matching in Sheet2

NoData if wrpt to ID CountryName is not present in Sheet 2

Cell D2=IF(Sheet2!B2="","No Data",IF(A2&LEFT(C2,FIND("|",C2)-1)=LEFT(Sheet2!A2,FIND(" ",Sheet2!A2)-1)&Sheet2!B2,"Match","Nomatch"))