title: Excel Lookup with absolute table reference
body: <p>I am trying to do a Lookup() on  a table of dates (and other info). To do this I have the following function:</p>
  
  <pre><code>=LOOKUP(DATE(2016,5,P6), Table1[Date], Table1[Paper Name])
  </code></pre>
  
  <p>where P6 is the day I want to look for. I want to drag this across to other days, but it changes which table column it refers to. I have tried:</p>
  
  <pre><code>=LOOKUP(DATE(2016,5,P6), Table1[[Date]:[Date]], Table1[[Paper Name]:[Paper Name]])
  </code></pre>
  
  <p>as suggested by the internet but it gave incorrect results where, if there wasn't a result for that cell, it would just use the last correct match. </p>
  
  <p>Thanks in advance, any help is greatly appreciated</p>