title: Combining COUNT IF AND VLOOK UP EXCEL
body: <p>I have multiple spreadsheets in a <code>workbook</code> and I would like the following in basic <code>English</code> talk:</p>
  
  <p>IF <code>worksheet1(cell)A3</code>, appears in 'worksheet2' column B - count how many times it appears in column b 'worksheet 2'</p>
  
  <p>So in other words - Lets say <code>A3</code> = BOB smith - in work sheet 1
  and appears 4 times in worksheet 2 - I want the formula to count the fact that <code>A3</code> 'Bob smith' is in worksheet 2 4 times, and come back and tell me 4.</p>
  
  <p>I have attempted to do separate calculations - with use of Vlookups - then in another cell to count/do if statement
  for example</p>
  
  <pre><code>=COUNTIF(VLOOKUP(A9,'To retire'!J:J,9,1))
  =IF(J228=O233, 'worksheet2'!F440,0)
  =VLOOKUP(A3,'worksheet2'!A:A,1,1)
  </code></pre>
  
  <p>Help would be very much appreciated, I am very stuck - I am unsure if I am looking into this too deeply or not enough! Thank you in advance</p>