Index and Match not returning the correct value

[karstens]

I am trying to do the index and match function and all my results come back NO when there should be some YES and #NA.
I have uploaded an example.
So basically I use a DATABASE tab to look up on the Report Filter tab for a match. I am looking at two columns, a code and description. On the report filter tab, it lists code, description and YES or NO if it it should be used for reporting.
If a match is found on both tabs, then it should return the answer yes, no or #NA on the database tab. I am using excel 365.
Thanks in advance for your expertise.

[Gregb11]

2 things:
Change the 0 to a 1 in your MATCH formula, and add the 0 for an exact match, i.e.,

=INDEX('Report Filter'!$C$2:$C$13,MATCH(1,('Report Filter'!$A$2:$A$13=C2)*('Report Filter'!$B$2:$B$13=D2),0))

There are some that you say should be "YES" or "NO", but are N/A because it's not a match (i.e., row 3 code = PRES but the Code on Report Filter is PRESM, not PRES