title: Excel INDEX MATCH when value may be in one of 3 columns
body: <p>I am using INDEX/MATCH to find values in a single column and return the value from a different column using:</p>
  
  <pre><code>=INDEX(Sheet1!$A:$A,MATCH(A2,Sheet1!$B:$B,0))
  </code></pre>
  
  <p>This will search to see if <code>A2</code> matches a value in Sheet1 column <code>B</code>, and if so will return the value from that row in column <code>A</code>.</p>
  
  <p>However, the value that is being searched might actually be in column <code>B</code>, <code>C</code> or <code>D</code> and I would like to be able to search for these values in the same query.</p>
  
  <p>I was hoping that the following would work, but it does not:</p>
  
  <pre><code>=INDEX(Sheet1!$A:$A,MATCH(A2,Sheet1!$B:$D,0))
  </code></pre>
  
  <p>Is there a way to do this simply without <code>IF</code> statements?  I have a version working with 3 columns using an <code>IF</code> statement but it seems that there should be a much easier way around it.</p>