title: Excel - Finding a string in another workbook with formula
body: <p>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.</p>
  <p>This is what I tried:</p>
  <pre><code>=IF(ISNUMBER(MATCH(AG2,'[RECEIVING.xlsx]1'!$B:$E,0)),1,0)
  </code></pre>
  <p>AG column is where ISBN-13 numbers are located.</p>
  <p>But the result that I got is 0 in every cell in that column. But there should be matches. What am I doing wrong?</p>