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