Index: cross reference a row & column to return a value

Hello,

I am trying to figure out a formula that will cross reference a number across a row & column.

Please note that the example used was created to keep this as simple as possible.

I am attempting to use an index function to perform the cross reference, however I get an error in the column portion.

• Did not use concatenates because my column header has over 20 variables I need to check against
• I would hope to search across row 5 to match the "BLUE".

=INDEX(LIST,MATCH(A11,A1:A6,0),HELP)

FORUM QUESTION.PNG