I'm working on allocating all 50 states to three names sales reps.
I need a formula that will allow me to allocate each state abbreviation (CA, NY, LA, KY... etc.) in column J and have column K auto populate with the one of three names.
Any help would be much appreciated.
[SOLVED]
Last edited by skeithnavo; 03-12-2015 at 07:33 PM.
Hello skeithnavo,
Welcome to the Forum!
On "Sheet2" of the attached workbook are two columns: State and Rep. The fifty states are divided among three reps.
On "Sheet1" in columns J2:J51, the cells have Validation Drop Downs to let you select a state.
In Cells K2:K51 is this formula: =IFERROR(VLOOKUP(J2,StateRep,2,FALSE),"")
This formula looks up the Rep for the selected State using the named range "StateRep" on "Sheet2". "StateRep" is range A1:B51.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
That is great! Thank you so much! Exactly what I needed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks