title: VBA - check if a string is is 1 of those in a column of a different sheet, in an if statement
body: <p>Hello i want to simpify the formula from </p>
  
  <pre><code>If InStr(1, Sheets("Le 2250").Cells(i, 1).Value, "250-") Or _
  If InStr(1, Sheets("Le 2250").Cells(i, 1).Value, "135-") Or _
  If InStr(1, Sheets("Le 2250").Cells(i, 1).Value, "700-")
  </code></pre>
  
  <p>to have the "250-" be 1 of the values in a column of a specific sheet, rather than having to put many "Or if ()" functions with the numerous strings i have to lpok for</p>
  
  <p>Any help appreciated.</p>