title: Get column by finding value in the row
body: <p>In Excel, I've looked into <code>hlookup</code>, <code>vlookup</code>, <code>match</code> and <code>index</code> but none of these functions do following:</p>
  
  <p>I need to find a text value in <code>A1:Z1</code> and get the column of it. For example, I found the value in <code>F1</code>, then I want a result <code>F:F</code>.</p>
  
  <p>EDIT: This is the function I want it to be added to: </p>
  
  <pre><code>=COUNTIFS(Source!B:B;Result!C3;Source!AT:AT;Result!$D$2)
  </code></pre>
  
  <p>I need the <code>Source!B:B</code> and alternatively <code>Source!AT:AT</code> be a search function that looks for a specific value in my table row and column in different sheet (Source).</p>