index match with multiple criteria to create list

[Bob_ipc]

Hello,

I find myself needing some help on a problem I am having. I am looking to get a list from my Entry tab that meets two criteria, the two criteria are the date and Project Name. I am trying to use Index Match but have not yet gotten very far. Can anyone help?

Thanks in advance

 

[Cubist]

Book2.xlsx
	A	B	C
1
2
3	Project Name	Date	Equipment
4	Project A	Feb/25/2024	Chain saw
5	Project B	Feb/28/2024	John Deer
6	Project C	Mar/2/2024	Vechicle
7	Project A	Mar/4/2024	Crew truck
8	Project A	Mar/4/2024	travel rate
9	Project A	Mar/4/2024	On-site
10	Project A	Mar/4/2024	Meals
11	Project A	Mar/4/2024
Entry

Book2.xlsx
	A	B	C	D	E	F	G	H	I	J
2	Project Name	Project A
3
4
5
6									Work Date	March 04,2024
7
8	Equipment
9	Crew truck
10	travel rate
11	On-site
12	Meals
13	0
14
15
Summary

Cell Formulas
Range	Formula
A9:A13	A9	=FILTER(Entry!C4:C11,(Summary!$B$2=Entry!A4:A11)*(Summary!$J$6=Entry!B4:B11),"Not found")
Dynamic array formulas.

 

[KRice]

We're glad you got it working....happy to help.

 

[Cubist]

Try

=FILTER(Entry!C4:C13,(Entry!A4:A13=B2)*(Entry!B4:B13=J6))

 

[KRice]

@Cubist...double check the filter criteria ranges. Should be single columns. The OP may have to adjust the date and project cell addresses...difficult to be sure from the images.

 

[Bob_ipc]

Try

=FILTER(Entry!C4:C13,(Entry!A4:A13=B2)*(Entry!B4:B13=J6))

Hey thanks for the quick response, however when adding this formula into A10 it just returns #VALUE!

 

[Cubist]

Hey thanks for the quick response, however when adding this formula into A10 it just returns #VALUE!

Can you post the sample sheets using XL2BB? As @KRice said, it's hard to tell the cell reference from the picture. Additionally, it might have to do with your date format.

 

[KRice]

Also, if the FILTER function does not find any matches, you'll see an error, unless the error is trapped. Are you certain that something should be found?

 

[Bob_ipc]

I am unfortunately not able to use XL2BB as it says it is not supported in protective view, not sure why it is saying this. My date format is just the standard short date format you can select and I double checked and the two criteria selected do exist it the Entry tab. I still can't get it t work.

 

[Bob_ipc]

Also, if the FILTER function does not find any matches, you'll see an error, unless the error is trapped. Are you certain that something should be found?

Could it be because I have Merged and Centered Cells?