Hi,
I am trying to return several columns of data for a subset of rows from a table that has all rows. I have used the index/match function and made the index function an array. But I can only return the first column. I want all the columns for each row. Thanks in advance for help. See attached example. Data sheet contains all rows and the columns of data. Query contains the subset. Solution contains a manual entry of what I am trying to obtain. I am trying to do this for hundreds of rows and columns so a formula would be better than by hand.
Jennifer
Bookmarks