title: Find a value in a range (any of multiple column or rows) and return the value in far left most column of that row
body: <p>Looking for something like a typical index match formula that can look to the right and return value to the left, but look at <em>all</em> columns in a range. Take below valid formula for example.</p>
  <p>(Excel 2021.)</p>
  <p>Finds A1's value in column D, and it returns value from column C.</p>
  <pre><code>=INDEX($C$1:$C$10,MATCH(A1,$D$1:$D$10,0))
  </code></pre>
  <p>In my ideal world I can Keep $D$1 and change $D$<strong>10</strong> to $F$10 so it searches all columns D/E/F, and still returns C like below. However that does not work in our real world, any other ideas please? Thanks!</p>
  <pre><code>=INDEX($C$1:$C$10,MATCH(A1,$D$1:$F$10,0))
  </code></pre>
  <p>Update*
  To clarify there are mix of letters and numbers. Also this table will be about 50k rows so hoping as simple as possible.</p>
  <p>Also Column C will all be unique for sure, and D-F should be unique values but there is a chance a mistake and a few duplicates might be in.</p>