title: EXCEL: Return value from row where id matches and date is the latest
body: <p>I would appreciate your help creating the following EXCEL formula. I have two sheets: assets and transactions.</p>
  
  <p>In the <strong>ASSETS sheet</strong>, each asset has a unique id. It looks like this:</p>
  
  <pre><code>A      C      ...  H
  ------------------------
  ID    ASSET      WHERE
  1     ntbk       [formula]
  2     tablet     [formula]
  3     headset    [formula]
  </code></pre>
  
  <p>In the <strong>TRANS sheets</strong> there are records of transactions for each asset. However, each asset has multiple transaction records.</p>
  
  <pre><code>   A           E          G
  --------------------------------
  AssetID    TransDate    Where
     1       20161101     storage
     3       20161103     Johnny B. Good
     1       20161106     Joe Smith
  </code></pre>
  
  <p>I need to determine the <strong>[formula]</strong> which would return the value from TRANS sheet column E where ID matches and the date is the latest. Basically, I need to know where the asset is now. So far, I haven't been successful. I'd appreciate your help.</p>
  
  <p>Thanks :)</p>