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]

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?

 

[Cubist]

In your summary, your workday is 3/14. There's nothing in the entry tab that has the date 3/14. If you're certain that the references are correct the formatting isn't an issue, and there's nothing to return then try this...

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

 

[KRice]

Could it be because I have Merged and Centered Cells?

Yes...that's the point about the cell address. The image doesn't tell us if the project name is in B2 or C2...and date in J6 or K6. You may need to adjust those references in the formula to point to the correct cell(s).