[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