title: Using Match and Address functions within Macro or VBA
body: <p>I have two worksheets, I want to use a value in sheet <code>to_approve</code> to lookup against <code>column A</code> in sheet <code>submitted</code>, then identify the cell reference so I can paste a value in the cell adjacent (<code>column B</code>).</p>
  
  <p>I have used the following to identify the cell reference, but I don't know how to use it in VBA code.</p>
  
  <pre><code>=ADDRESS(MATCH(To_Approve!D19,Submitted!A:A,0),1,4,1,"submitted")
  </code></pre>