|
Formula
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 |
Formula
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 |
Formula
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 |
Formula
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 |
Formula
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 |
| All times are GMT +1. The time now is 11:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com