title: VLOOKUP across two worksheets (with an IF?)
body: <p>Doing a simple <code>VLOOKUP</code> on a cell to return a date from another worksheet like below</p>
  
  <p><code>=VLOOKUP(A46,'ECA AW12'!B92:AO133,15, 0)</code></p>
  
  <p>Essentially, look up cell A46, and check it against <code>B92:AO133</code> on the sheet ECA AW12, if true then return value of cell 15 on same row of table as match</p>
  
  <p>However… what if A46 isn’t on that worksheet? It can appear in one of two spreadsheets. </p>
  
  <p>I suppose logically addressing it, an function would be required to search for the value in the first spreadsheet, and if it isn't there perform a <code>VLOOKUP</code> on the second sheet.</p>
  
  <p>Any help is greatly appreciated,</p>