• 0

[EXCEL] Need help with table formulas


Question

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

  • 0

You still need help with this? If so try this...

I've added an extra column to concatenate the two values on the table sheet that are being looked up (COLUMN F) - the formula in this column will need to be repeated down for each entry in the table.

Then I've used INDEX and MATCH to do a lookup on the table when you enter both STATE and CODE.

http://www.filefront.com/15313781/Book.xls

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.