I'm trying to index a table that has four possible row arrays.

INDEX(ARRAY,MATCH(Value, MATCH HEADER IN THE FOUR POSSIBLE ROW ARRAYS,0),1)

Variable Row Array.xlsx

I figured this was possible, I just couldn't figure out how to complete a lookup within the match function. Thanks in advance of your help.