title: INDIRECT with column reference and row reference in different cells
body: <p>So I have two cells, both referring to another sheet. One cell has the row of the other sheet and another has the column. </p>
  
  <p>I tried using an indirect statement along the lines of this: <code>=INDIRECT("'VENDOR COSTING'!R"&amp;R2&amp;"C"&amp;S2)</code> Although I did do a ConvertToLetter so the column letter is <code>F</code> and it is currently in Cell <code>U2</code>. <code>Vendor costing</code> is the other sheet name and the row number is in cell <code>R2</code>.</p>
  
  <p>How can I write an indirect statement to produce the value in that cell on the other sheet? </p>