title: Excel Match function with columns having R1C1 reference style
body: <p>I am using excel to look through my data, I have a matrix of 2000 columns and thousands of rows.
  I want to search for some string in a specific column. I've been reading online and the <code>Match()</code> function is usually used for this. I am not sure of 2 things actually: </p>
  
  <p>1-how to formulate the command since I have my columns as R1C1 reference style? (I mean I have numbers instead of letters as columns names)</p>
  
  <p>2- I don't know how many rows I have, I just want the function to search the entire column for this string.
  Here's the command I found, which doesn't solve any of the 2 problems mentioned above</p>
  
  <pre><code>=MATCH("string",A1:A100, 0) 
  </code></pre>
  
  <p>Thanks,</p>