BOM comparison - excel function

Question

I need to check if data from the current BOM ERP(article + quantity) is the same or have some differences from the master file (article + quantity).

I tried to do it with xlookup/if function but every time some error occurs, as it can be visible in the photo 2. For both equal data, function shows that the values are different. I don't know what can be the cause when all the data has the same format.

Answer 1

The functions I used:

=XLOOKUP(C4,H4:H35,H4:H35,"nije pronadjeno")

=IF(COUNTIF(H6:H37,C6)=0,"ZA BRISANJE","OK")

I couldnt attach the excel file in this form.