title: Using indirect function in an IF statement with quotes
body: <p>I'm making multiple IF statements that are going to have the same layout. Instead of writing the reference sheet name I'd like to reference a cell for the sheet name.</p>
  
  <p>Also in the interests of laziness I'd like to drag the formula so it changes locations it is looking at on the referenced sheet.</p>
  
  <p>At the moment it looks like this.</p>
  
  <pre><code>=IF(sheet1!O2="","",sheet1!O2)
  </code></pre>
  
  <p>Simple enough.</p>
  
  <p>However I want to use indirect and I can't write it without getting an error.</p>
  
  <p>Last attempt was</p>
  
  <pre><code>=IF((indirect($B$3))!O2="","",(indirect($B$3))!O2)
  </code></pre>
  
  <p>where <code>Sheet1</code> is in the cell <code>B3</code></p>
  
  <p>Doesn't work.</p>
  
  <p>Any help on the correct syntax would be very appreciated.</p>