Need Formula to return the column heading in a table based on a value located in the table

I have a table that has 8 columns and 19 rows (including the headings). The columns are 4 regions (with state abbreviations below each) and 4 columns for the number of contracts in each region (with the number of contracts next to the corresponding state).
I have another sheet with a list of all 50 states, and in the column next to that list, I'd like a formula to pull the corresponding region name from the table. So essentially, it needs to find the state abbreviation location and look upwards rather than down. I've tried combos of index/match as well as some other functions, but can't get it. Also, I've tried to get using an array formula, but I've never really used those and I'm unfamiliar with them. Brief example below with 4 of the 8 columns.

West Region # Contracts Central Region # Contracts
BC 1 ND 1
WA 157 SD 0
OR 6 NE 0

Thanks in advance,

An example workbook would be useful

With INDEX and MATCH you should be able to do what you want

Are you able to restructure your Table sheet? I would recommend you do so.

Put ALL the states in one column. In the adjacent column put the corresponding region and in the next adjacent column put the " Contacts.

Then, you could use a simple VLOOKUP function to get the info you need.

See if this helps:

http://contextures.com/xlFunctions02.html

With current setup, try this in B4:

Formula:

Please Login or Register  to view this content.

But Tony is right, it would/will make your formulas a LOT easier if the data was in 1 column rather than 4

Hope this helps

Edit-
The above would have been about 1/6 the size if the data was in single columns

My Bad, left out the "="

Formula:

Please Login or Register  to view this content.

Sorry about that

However to show what it might look like with Tony's suggestion:gfalcone1.sol1.xlsx
Column C contains this MUCH easier to use formula:

Formula:

Please Login or Register  to view this content.

See the difference?

Hope this helps

Try this array formula**:

=INDEX(Table!$3:$3,MAX(IF(Table!A$4:H$20=A4,COLUMN(Table!A$4:H$20))))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down as needed.