Hello -
I would like to use Named Ranges in an array formula.
I have a dataset on one tab and a summary table on another tab.
Here is what I am trying to accomplish:
Pull data from columns B,C and D (for example) based on column A being equal to number 1.
Pull data from columns B,C and D based on column A being equal to number 2.
etc, etc, etc
The dataset is updated monthly and therefore the number of rows increases.
Is there a way to do this?
I have searched this group and could not find an answer, unless it was there and I didn't understand it. I saw a couple of examples that used CHOOSE and MATCH together, but I have never either function before and could not figure out if that combination would work for me.
Any help would be appreciated!
Regards
Pat
Bookmarks