excel - Check and compare 2 values from two different sheets -

i have 2 workbooks named a.xlsx , b.xlsx of both have same columns.

so under a.xlsx1 there column named taglist have values :

7btg4|34cyn 7huir|yuid4|uid78 rtgh3

and in b.xlsx there column named taglist user have input values based on judgement. correct answers in a.xlsx. below values b.xlsx

34cyn|7btg4  yuid4|7huir|uid78  rtgh3

if notice values interchanged in b.xlsx.

so when apply =if(a2=[b.xlsx]sheet1!$a$2,1,0) give false

i have 1000's of row check. can help?

thanks in advance

hj