software

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:

www.contextures.com/xlFunctions02.html

Does that help?

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

XL2002, WinXP-Proquot;CraigMquot; wrote:

gt; I have a created an excel spreadsheet which looks something like the below.
gt;
gt; Date - BranchCode - Branch - Type - Complaint - RM
gt;
gt; When the user inputs the 3 letter branchcode, the branch name appears in the
gt; Branch field.
gt; eg. SUN will fill in the Branch column as Sunderland.
gt; Again when the user puts a certain letter in the Type box, it fills in the
gt; Complaint column.
gt;
gt; What i want is for the RM box which is Regional Managers to be filled in
gt; depending on what is put in the Branch Column.
gt;
gt; We have 10 RM's and each of them have certain branches. So depending on what
gt; Branch it is i would like the RM column to bring back the RM's full name.
gt;
gt; Is this possible.
gt;
gt; Regards
gt;
gt; 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

quot;Ron Coderrequot; wrote:

gt; It think the VLOOKUP function will do what you need:
gt;
gt; www.contextures.com/xlFunctions02.html
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;CraigMquot; wrote:
gt;
gt; gt; I have a created an excel spreadsheet which looks something like the below.
gt; gt;
gt; gt; Date - BranchCode - Branch - Type - Complaint - RM
gt; gt;
gt; gt; When the user inputs the 3 letter branchcode, the branch name appears in the
gt; gt; Branch field.
gt; gt; eg. SUN will fill in the Branch column as Sunderland.
gt; gt; Again when the user puts a certain letter in the Type box, it fills in the
gt; gt; Complaint column.
gt; gt;
gt; gt; What i want is for the RM box which is Regional Managers to be filled in
gt; gt; depending on what is put in the Branch Column.
gt; gt;
gt; gt; We have 10 RM's and each of them have certain branches. So depending on what
gt; gt; Branch it is i would like the RM column to bring back the RM's full name.
gt; gt;
gt; gt; Is this possible.
gt; gt;
gt; gt; Regards
gt; gt;
gt; gt; 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-Proquot;CraigMquot; wrote:

gt; Hi,
gt;
gt; Thanks for the quick reply.
gt;
gt; I have tried this but i cannot get it to work. I may be doing it wrong.
gt;
gt; Regards
gt;
gt; Craig
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; It think the VLOOKUP function will do what you need:
gt; gt;
gt; gt; www.contextures.com/xlFunctions02.html
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;CraigMquot; wrote:
gt; gt;
gt; gt; gt; I have a created an excel spreadsheet which looks something like the below.
gt; gt; gt;
gt; gt; gt; Date - BranchCode - Branch - Type - Complaint - RM
gt; gt; gt;
gt; gt; gt; When the user inputs the 3 letter branchcode, the branch name appears in the
gt; gt; gt; Branch field.
gt; gt; gt; eg. SUN will fill in the Branch column as Sunderland.
gt; gt; gt; Again when the user puts a certain letter in the Type box, it fills in the
gt; gt; gt; Complaint column.
gt; gt; gt;
gt; gt; gt; What i want is for the RM box which is Regional Managers to be filled in
gt; gt; gt; depending on what is put in the Branch Column.
gt; gt; gt;
gt; gt; gt; We have 10 RM's and each of them have certain branches. So depending on what
gt; gt; gt; Branch it is i would like the RM column to bring back the RM's full name.
gt; gt; gt;
gt; gt; gt; Is this possible.
gt; gt; gt;
gt; gt; gt; Regards
gt; gt; gt;
gt; gt; gt; Craig

That worked fine.

Thanks for your help

quot;Ron Coderrequot; wrote:

gt; You should have a list that matches BranchCode with RM:
gt;
gt; Example(Brand/Mgr list in Y1:Z10:
gt; Col_Y___Col_Z
gt; 1001___D Murphy
gt; 1002___L Stanton
gt; etc
gt;
gt; For a BranchCode in B2
gt; The RM formula would be:
gt; F2: =VLOOKUP(B2,$Y$1:$Z$10,2,0)
gt;
gt; If you still have problems, post your formula.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;CraigMquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; Thanks for the quick reply.
gt; gt;
gt; gt; I have tried this but i cannot get it to work. I may be doing it wrong.
gt; gt;
gt; gt; Regards
gt; gt;
gt; gt; Craig
gt; gt;
gt; gt; quot;Ron Coderrequot; wrote:
gt; gt;
gt; gt; gt; It think the VLOOKUP function will do what you need:
gt; gt; gt;
gt; gt; gt; www.contextures.com/xlFunctions02.html
gt; gt; gt;
gt; gt; gt; Does that help?
gt; gt; gt;
gt; gt; gt; ***********
gt; gt; gt; Regards,
gt; gt; gt; Ron
gt; gt; gt;
gt; gt; gt; XL2002, WinXP-Pro
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;CraigMquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a created an excel spreadsheet which looks something like the below.
gt; gt; gt; gt;
gt; gt; gt; gt; Date - BranchCode - Branch - Type - Complaint - RM
gt; gt; gt; gt;
gt; gt; gt; gt; When the user inputs the 3 letter branchcode, the branch name appears in the
gt; gt; gt; gt; Branch field.
gt; gt; gt; gt; eg. SUN will fill in the Branch column as Sunderland.
gt; gt; gt; gt; Again when the user puts a certain letter in the Type box, it fills in the
gt; gt; gt; gt; Complaint column.
gt; gt; gt; gt;
gt; gt; gt; gt; What i want is for the RM box which is Regional Managers to be filled in
gt; gt; gt; gt; depending on what is put in the Branch Column.
gt; gt; gt; gt;
gt; gt; gt; gt; We have 10 RM's and each of them have certain branches. So depending on what
gt; gt; gt; gt; Branch it is i would like the RM column to bring back the RM's full name.
gt; gt; gt; gt;
gt; gt; gt; gt; Is this possible.
gt; gt; gt; gt;
gt; gt; gt; gt; Regards
gt; gt; gt; gt;
gt; gt; gt; gt; Craig