Rules based auto fill in Google Docs / Excel

Rules based auto fill in Google Docs / Excel

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.
example:
Data:
HEAD - Imported Field - Payees (autofill) - Account (autofill)
ROW1 - payment to JASON U - Jason Ure - Drawings
ROW2 - 234322 MERCHANT FEES - CBA - Fees
Rules:(separate sheet)
HEAD - Matched Term - Payee - Account
ROW1 - JASON U - Jason Ure - Drawings
ROW2 - MERCHANT - CBA - Fees
I'm guessing it's a combination of FIND, VLOOKUP but haven't managed to
figure it out. Any help much appreciated. I am working in google
spreadsheets, so am hoping for an answer that will work here.