i have 4 areas north east south and west, what is the forumla to enter into a cell that would automatically add the Salesperson when you know the area
Table is
Date, Area, (FORMULA), Amount
13/11/09, North, ( ), Amount
Basically there is a table with the salesperson per area
if i was writing it i would say its as follows
If Area = North then Mr Smith else if Area - South then Mr Jones etc etc
without more info it's hard to give an example (ie where is your table) ... anyway see VLOOKUP in XL Help.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hello Simon4sam,
You can use following formula :-
=IF(B2="North","Mr.Smith",IF(B2="South","Mr Jones",0))
for more details please check the attached file.
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
10/09/09 North 101
01/10/09 East 55
13/01/09 South 59
11/02/09 West 12
02/03/09 West 35
04/07/09 North 110
07/07/09 South 69
24/11/09 North 30
22/12/09 East 2
12/12/09 South 34
15/01/09 East 75
15/02/09 West 101
25/04/09 South 169
10/09/09 West 23
01/10/09 North 14
13/01/09 North 45
11/02/09 East 68
02/03/09 South 23
04/07/09 West 99
07/07/09 East 76
24/11/09 North 31
22/12/09 South 42
12/12/09 South 53
15/01/09 West 69
15/02/09 North 199
25/04/09 East 34
Column A = Date
Column B = Area
Column C = (WHERE I ADD MY FORUMLA) - Salesperson
Column D = Amount
Separate Table
North Mr Smith
West Mr Jones
East Mr Evans
South Mr Adams
Should be a simple formula that looks up the values in the second table and returns into column C the salesperson
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.
Hello,
try following formula in "C" coloum
=IF(B2="North","Smith",IF(B2="South","Jones",IF(B2="East","Mr.X",IF(B2="West","Mr Y",0))))
Hello
or you can use following formula as well
=VLOOKUP(B2,F:G,2,0)
check the attached file.
Originally Posted by Rahul Nagar
For some reason they all work fine except East which returns 0, ive double checked and checked again and cannot see whats up i copied the cell downwards!
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc
Thread closed
After reading the rules you may contact a moderator or Administrator to have your thread reopen
When contacting a moderator you must state that you agree to obey the sites rules & list what you want the thread title changed to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks