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
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"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks