title: Rules based auto fill in Google Docs Spreadsheets
body: <p>I am making a bookkeeping sheet. </p>
  
  <p>The aim is to create rules, that search imported fields from our bank statement, and if a match is found automatically fill the adjoining cells with the rules data. </p>
  
  <p>example: </p>
  
  <p>Data:</p>
  
  <pre><code>HEAD - Imported Field       - Payees (autofill) - Account (autofill)
  ROW1 - payment to JASON U   - from rule below   - from rule below
  ROW2 - 234322 MERCHANT FEES - from rule below   - from rule below
  </code></pre>
  
  <p>Rules:(separate sheet)</p>
  
  <pre><code>HEAD - Matched Term - Payee     - Account
  ROW1 - JASON U      - Jason Ure - Drawings
  ROW2 - MERCHANT     - CBA       - Fees
  </code></pre>
  
  <p>We have this working in Excel now, but need to get it working in Google Spreadsheets. 
  Anyone know how to convert this?</p>