title: IF + INDIRECT Excel
body: <p>I have been trying for hours to get the <code>=IF(INDIRECT...</code> Funktion to work, but i cant get it to work.</p>
  
  <p>Hope you can help me out.</p>
  
  <p>I have 3 worksheets (<code>Calender</code>, <code>sheet1</code>, <code>sheet2</code> (up to 50)) </p>
  
  <p>In Calender I have different "inputs" like <code>Name(A1)</code>, <code>City(A2)</code>, <code>Number(A3)</code> etc.</p>
  
  <p>On <code>A4</code> Ii have a booking number. This booking number refers to <code>sheet1</code> or <code>sheet2</code></p>
  
  <p>In <code>sheet1</code> and <code>sheet2</code> I have the same "inputs" </p>
  
  <p>What I would like to, is when I type <code>sheet1</code> in <code>Calender</code> on <code>B4</code> it fills in <code>B1+B2+B3</code> with the info from sheet1 <code>A1+A2+A3</code></p>
  
  <p>If i insted used <code>sheet2</code>in <code>Calender!B4</code>, it would fill in the info from <code>sheet2</code></p>
  
  <p><img src="https://i.stack.imgur.com/fMnSg.png" alt="simplified"></p>