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.