I am making a bookkeeping sheet.

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.



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

Rules:(separate sheet)

HEAD - Matched Term - Payee     - Account
ROW1 - JASON U      - Jason Ure - Drawings
ROW2 - MERCHANT     - CBA       - Fees

We have this working in Excel now, but need to get it working in Google Spreadsheets. Anyone know how to convert this? (see in skydrive/excel below) http://puu.sh/4DVsJ.png

1 Answer 1


At this time, the LOOKUP function is available in the New Google Sheets.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.