Returning list from 3D array

I have a weekly (Saturday) market and 40 vendors. I have a matrix with months as the rows and Saturday dates as the columns (1-5). I ask vendors to check the dates they want to be there. I create wor...

Formulas & Functions

functions

Matt Mickle
Jun 08, 2018
Paul-

Just wanted to check back in and see if you were able to resolve your issue with the sample file provided?

Matt Mickle

Bronze Contributor

May 21, 2018

Paul-

I think this is a better setup.

Try these modifications:

1. Have one worksheet for all vendors

2. Have a Vendor Dropdown

3. Have a month Drop Down

4. Have a weekend Dropdown

5. Have a Query Worksheet that will tell you, who will perform or be in attendance on X date.

I've set it up where the dates of the Saturday's will narrow down to a specific month when the month is selected. i.e. If you select February it will only show Saturday's in February. If you select March it will only show Saturday's in March.

Use an array formula to help identify the vendors for a particular Saturday:

={IFERROR(INDEX(Data!$A$2:$C$100,SMALL(IF(Data!$C$2:$C$100=Criteria,ROW(Data!$A$2:$C$100)-1),ROW(2:2)),COLUMN()),"")}