I have a created an excel spreadsheet which looks something like the below.

Date - BranchCode - Branch - Type - Complaint - RM

When the user inputs the 3 letter branchcode, the branch name appears in the
Branch field.
eg. SUN will fill in the Branch column as Sunderland.
Again when the user puts a certain letter in the Type box, it fills in the
Complaint column.

What i want is for the RM box which is Regional Managers to be filled in
depending on what is put in the Branch Column.

We have 10 RM's and each of them have certain branches. So depending on what
Branch it is i would like the RM column to bring back the RM's full name.

Is this possible.

Regards

Craig