I have ISBN-13 numbers in a column. I want to search and find each of them in another workbook with a formula and to write 1 if there is a match and 0 if there is no match in another column next to ISBN-13 numbers.
This is what I tried:
=IF(ISNUMBER(MATCH(AG2,'[RECEIVING.xlsx]1'!$B:$E,0)),1,0)
AG column is where ISBN-13 numbers are located.
But the result that I got is 0 in every cell in that column. But there should be matches. What am I doing wrong?