title: Using Index Match where a match lookup can be one of multiple values
body: <p>The below formula is an index-match that accurately returns the value <code>Calibrate Temperature Tx</code> if it is found within my dataset.</p>
  <pre><code>=INDEX('Equipment Strategy Review'!$C$6:$AK$3983,MATCH(1,('Equipment Strategy Review'!$C$6:$C$3983=[@[Corrected Equipment Tag]])*('Equipm**strong text**ent Strategy Review'!$AK$6:$AK$3983=&quot;Calibrate Temperature Tx&quot;),0),35)
  </code></pre>
  <p>I need to expand this formula to also return values such as <code>Calibrate Pressure Tx</code> or <code>Calibrate Flow Tx</code> if found. How can this be achieved?</p>
  <p><strong>Note</strong>: No individual piece of equipment (Field C in Equipment Strategy Review) will have more than one record containing any of these strings i.e. Equipment A can only have a one of these calibration tasks, not all 3.</p>