Originally posted in software assistance but perhaps this would be a better suited section... Thanks for anyone who can help
Ok, I am normally pretty good with Excel but this table option is just not working at all. Here is what I am looking to do (someone can tell me that this is not possible as well as I really dont know"
Sheet1 tab will have 4 columns - State/Code/Action/Description
I would like to be able to enter in the state/code field and then the action/description will be returned based on the Table tab
Table tab will have 4 columns - State/Code/Action/Description
State will include all 50 state abbreviations + a ALL category
Code will be a 5 or 6 digit unique numerical #
Action will be N/A, ADDN, ADDJ
decription will be open text and may or may not be duplicated throughout the table
I feel like it sounds easy but any of the forumlas I try do not seem to work. Thanks to anyone who can help i feel like I have been working on this for weeks...
Question
jerzdawg
Originally posted in software assistance but perhaps this would be a better suited section... Thanks for anyone who can help
Ok, I am normally pretty good with Excel but this table option is just not working at all. Here is what I am looking to do (someone can tell me that this is not possible as well as I really dont know"
Sheet1 tab will have 4 columns - State/Code/Action/Description
I would like to be able to enter in the state/code field and then the action/description will be returned based on the Table tab
Table tab will have 4 columns - State/Code/Action/Description
State will include all 50 state abbreviations + a ALL category
Code will be a 5 or 6 digit unique numerical #
Action will be N/A, ADDN, ADDJ
decription will be open text and may or may not be duplicated throughout the table
I feel like it sounds easy but any of the forumlas I try do not seem to work. Thanks to anyone who can help i feel like I have been working on this for weeks...
sample can be found here
http://www.filefront.com/15258875/Book.xls
Link to comment
Share on other sites
1 answer to this question
Recommended Posts