Generating report using multiple criteria

[lai_arceo]

Hello, everyone.

I am hoping someone could help me with an index/match function to generate a report based on multiple criteria. I actually want to be able to copy a whole column of data based on 3 criteria that the user will fill.

Fig. 1 contains my database and Fig. 2 is the report I want to generate based on the week #, date and legend. I need the whole column copied to the "Reports" sheet depending on the 3 criteria.

Appreciate your kind assistance.

 

[Glenn Kennedy]

Try this instead.

BBB.xlsx
	A	B	C
1		47
2		13-Nov
3		*
4		Q
5		W
6		E
7		R
8		T
9
10
11
12
13
14
Sheet2

Cell Formulas
Range	Formula
B4:B14	B4	=INDEX(db!A:C,ROWS(B$1:B4),AGGREGATE(15,6,COLUMN(db!A4:C15)/((db!A1:C1=Sheet2!B1)*(db!A2:C2=Sheet2!B2)*(db!A3:C3=Sheet2!B3)),1))&""

 

[lai_arceo]

Try this instead.

BBB.xlsx
	A	B	C
1		47
2		13-Nov
3		*
4		Q
5		W
6		E
7		R
8		T
9
10
11
12
13
14
Sheet2

Cell Formulas
Range	Formula
B4:B14	B4	=INDEX(db!A:C,ROWS(B$1:B4),AGGREGATE(15,6,COLUMN(db!A4:C15)/((db!A1:C1=Sheet2!B1)*(db!A2:C2=Sheet2!B2)*(db!A3:C3=Sheet2!B3)),1))&""

This worked perfectly! Thank you!