title: Using the 'Match' function in Excel to return a cell address
body: <p>I have a list of numbers in a table that I would like to search for and bring back the cell reference of where that number resides.  For example the data looks like:</p>
  
  <pre><code>        A       B        C        D
  1       1       2        3        4
  </code></pre>
  
  <p>ok it doesn't come out very well as the first one is the row number and then each number below sits under each letter, so C1 would contain '3'....  </p>
  
  <p>If I wanted to return the reference number of C1 in a cell I am using the formula of <code>=CELL("address",MATCH(AU14,C1:AG1))</code> but this just errors.  I have tried to put an Index in there too, but I believe that index only works vertically so this bring back a #N/A result.</p>
  
  <p>Can anyone assist as I've wasted too much time on this already! :)</p>