title: IF ISNUMBER SEARCH
body: <p>I am trying to populate a <code>IF(ISNUMBER(SEARCH(</code> within VBA to automatically populate cells when a user puts a code in to a cell.</p>
  
  <p>I am getting an error when doing this.</p>
  
  <p>The code I am currently using is:<br>
  <code>Range("J19") = Evaluate("IF(ISNUMBER(SEARCH(""IWA"",""I19"")),""IWA"",""Not Working"")")</code></p>
  
  <p>I have 3 sheets to look up and match, so if I19 contains IWA or IWK I need it to look at that particular sheet. At the moment I am getting NOT Working as the formula result.</p>
  
  <p>Does anyone have any ideas?</p>
  
  <p>Thanks</p>