I am trying to drop assign an code based on a description value. The table is for street signs. When the user picks a description (Stop), the column next to it fills in with the code value (R1-1). I have A second spread sheet in my excel file with the description associating with the code number. I have tried using VLOOKUP and other options but cannot find a solution. I have uploaded my table.
1) Which cell are you asking for help on?
2) Which cell should that cell be "looking" at and which sheet name should it then refer to?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi welcome to the forum
try this for column C...
=VLOOKUP(B2,MUTCDCode!$A$1:$C$1017,2,0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ford, that doesn't work for "Speed Limit". Totally different results than they have in there currently. Truth is that's why I asked for more direction on what is needed and where. Column C isn't a 1-1 relationship. There are many "Speed Limit" codes.
What if I did the reverse, the MUTCD Codes are unique.
It actuually does work, Jerry, its just that there are 8 different "speed hump codes - I didnt notice that...
Speed Limit R2-1 Regulatory
Speed Limit R2-1-15 Regulatory
Speed Limit R2-1-20 Regulatory
Speed Limit R2-1-25 Regulatory
Speed Limit R2-1-30 Regulatory
Speed Limit R2-1-35 Regulatory
Speed Limit W13-115 Warning
Speed Limit W13-125 Warning
If you intend looking up the code and returning the name, try this...
=INDEX(Description,MATCH(SignInventory!$C2,MUTCD_Code,0))
However, with over 1000 codes, how whill you know which code to type in?
Yes, if you put in the MUTC code, and put that column into "A" of the MUTC sheet, then a simple VLOOKUP could pull back the description.
Another idea is to create a drop down in column C that only lists the options for the choice you made in column B. So if you select "Speed Limit", then column C would show only 8 choices in the drop down.
Thanks for all of the suggestions, I will try out a few and see what will work best.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks