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
Bookmarks