title: Using lookup,match, and indirect function
body: <p>First off thank you for your time. 
  I am having a little bit of an issue with an excel formula. This formula works but the problem I am having is that I need it for multiple cells with multiple sheets. Instead of writing 'Original Copy Center' I'd rather refer it to a cell that has a sheet name.</p>
  
  <pre><code>=LOOKUP(2,1/(MATCH('Original Copy Center'!10:10,'Original Copy Center'!10:10)),'Original Copy Center'!9:9)
  </code></pre>
  
  <p>I came up with the following formula, but with no success.</p>
  
  <pre><code>=LOOKUP(2,1/(MATCH((INDIRECT("'"&amp;A3&amp;"'!A10:Z10")),(INDIRECT("'"&amp;A3&amp;"'!A10:Z10")))),(INDIRECT("'"&amp;A3&amp;"'!A10:Z10")))
  </code></pre>
  
  <p>Regards</p>