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

It think the VLOOKUP function will do what you need:

http://www.contextures.com/xlFunctions02.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"CraigM" wrote:

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

Hi,

Thanks for the quick reply.

I have tried this but i cannot get it to work. I may be doing it wrong.

Regards

Craig

"Ron Coderre" wrote:

It think the VLOOKUP function will do what you need:

http://www.contextures.com/xlFunctions02.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"CraigM" wrote:

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

You should have a list that matches BranchCode with RM:

Example(Brand/Mgr list in Y1:Z10:
Col_Y___Col_Z
1001___D Murphy
1002___L Stanton
etc

For a BranchCode in B2
The RM formula would be:
F2: =VLOOKUP(B2,$Y$1:$Z$10,2,0)

If you still have problems, post your formula.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"CraigM" wrote:

Hi,

Thanks for the quick reply.

I have tried this but i cannot get it to work. I may be doing it wrong.

Regards

Craig

"Ron Coderre" wrote:

It think the VLOOKUP function will do what you need:

http://www.contextures.com/xlFunctions02.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"CraigM" wrote:

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

That worked fine.

Thanks for your help

"Ron Coderre" wrote:

You should have a list that matches BranchCode with RM:

Example(Brand/Mgr list in Y1:Z10:
Col_Y___Col_Z
1001___D Murphy
1002___L Stanton
etc

For a BranchCode in B2
The RM formula would be:
F2: =VLOOKUP(B2,$Y$1:$Z$10,2,0)

If you still have problems, post your formula.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"CraigM" wrote:

Hi,

Thanks for the quick reply.

I have tried this but i cannot get it to work. I may be doing it wrong.

Regards

Craig

"Ron Coderre" wrote:

It think the VLOOKUP function will do what you need:

http://www.contextures.com/xlFunctions02.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"CraigM" wrote:

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