title: Check if value exists in multiple sheets
body: <p>I have one excel with the following sheets</p>
  
  <pre><code>MAY
  JUNE
  JULY
  AUGUST
  </code></pre>
  
  <p>Inside each sheet i have one column (A) with around 200 rows and in each cell I have a 6 digit number.</p>
  
  <p>I would like to somehow in column (B) next to each number to check all sheets and if the number exists to return any text value for example "OK".</p>
  
  <p>So if I write the number "000000" in Sheet JULY, Column A, line 67 and this number exists in Sheet MAY, Column A, line 120, I would like to see the word "OK" in Sheet JULY, Column B, line 67</p>
  
  <p>What I have tried so far is:</p>
  
  <pre><code>=IFERROR(IF(MATCH(A2,MAY!$A:$A,0),"YES",),"NO")
  </code></pre>
  
  <p>But this one only checks one Sheet (MAY) I would like to have the option to check two or more Sheets.</p>
  
  <p>Thanks</p>