title: Use the Index and Match functions to return a specific cell that contains a key word "VAC"
body: <pre><code>=INDEX('[IHT Schedule 2020.xlsx]Jan - Dec  2021'!$L$18:$AP$79,MATCH($B10,'[IHT Schedule 2020.xlsx]Dec 2020'!$C$18:$C$79,0),MATCH(V$8,'[IHT Schedule 2020.xlsx]Jan - Dec  2021'!$L$17:$AP$17,0))
  </code></pre>
  <p>The formula works and returns: <code>10.5 VAC</code> from <code>IHT Schedule2020.xlsx</code> perfectly.</p>
  <p>But I have other cells that may contain <code>7:30-5:30 am</code>, or &quot;<code>off</code>&quot; , or <code>UED</code>.  I  want this formula to search out and return only the &quot;<code>10.5 VAC</code>&quot; values.</p>
  <p>My question is this possible with this formula or should I be doing this differently?</p>