[SOLVED]How to VLookup multiple items when the source has multiple identical numbers

I have a table that has status of Y and N. And next to it I have multiple identical invoice #. Y should only has one invoice. I only want to Vlookup (or index or match, I do not know) the ones that have Y status.

Please see my sample.

Thanks for the help.

Sample.xlsx

Try this formula

=SUMIFS(C$2:C$8,A$2:A$8,"Y",B$2:B$8,F11)

Alkey,

Thanks for the help. I just find out there is one more item needs to look up. Please see my sample again. I also need to match the item and look up the date. Please see my sample file

Attachment 358962



Thanks again for the help.

Here it is

=SUMIFS(E$2:E$8,A$2:A$8,"Y",B$2:B$8,H11,C$2:C$8,I11,D$2:D$8,J11)