title: VLOOKUP and Interpolating
body: <p>I am trying to check a table for specific data and if i found the data it will display the data. I did that with VLOOKUP. But now if the data is not in the table i want to interpolate between two sets of data. But i have no idea how to do it.</p>
  
  <p>So what i want to archieve is something that check if a number is in the table and if its not it needs to interpolate.</p>
  
  <p>Exapmle:</p>
  
  <pre><code>2,50           4523
  2,52           4687
  2,54           4790
  </code></pre>
  
  <p>I want: 2,50
  Display: 4523</p>
  
  <p>I want: 2,51 (It isnt there i want to interpolate (4687+4523)/2)</p>
  
  <p>Display: the interpolated number</p>
  
  <p>EDIT:</p>
  
  <p>Vlookup formula:</p>
  
  <pre><code>=VLOOKUP(F3;Tabel3;2;FALSE)
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/Xq0mL.png" rel="noreferrer">EXCEL Screenshot</a></p>
  
  <p><a href="https://i.stack.imgur.com/Xq0mL.png" rel="noreferrer"><img src="https://i.stack.imgur.com/Xq0mL.png" alt="enter image description here"></a></p>