How do I return 2 correct matches on another column?

[c.clavin]

Hi guys, I'd like to search column A and B for matches and spit out that items from Column C on Column D. Is this possible? I've used VLOOKUP in the past, but I'm not sure if this is the right tool for the job here. Ultimately I'd like to be able to use it in a dropdown, which I guess I could pull from the results if it won't work directly in the dropdown. Thanks!

Book2
	A	B	C	D
1	Costco	BJ's	Item	Items Both Stores Carry
2	Yes	No	Hot Dog
3	Yes	Yes	Soda
4	No	Yes	Pizza
5	Yes	Yes	French Fries
Sheet1

 

[Coyotex3]

How about this formula on cell D2

=IF(AND(A2="Yes",B2="Yes"),C2,"")

 

[c.clavin]

In my sheet there are multiple possibilities, I think I'd need a nested filter or something. This possible?

 

[Coyotex3]

In my sheet there are multiple possibilities, I think I'd need a nested filter or something. This possible?

Perhaps this would work:

=IFERROR(FILTER(C2,(A2="Yes")*(B2="Yes")),"")

 

[c.clavin]

Ah perfect thanks, I think I got it at the same time. This was my similar one. Thanks!

=FILTER(R3:R15,ISNUMBER(SEARCH('VARIABLE LUT'!$B$16,P3:P15))*ISNUMBER(SEARCH('VARIABLE LUT'!$B$12,Q3:Q15)))

 

[Peter_SSs]

Ah perfect thanks, I think I got it at the same time. This was my similar one. Thanks!

=FILTER(R3:R15,ISNUMBER(SEARCH('VARIABLE LUT'!$B$16,P3:P15))*ISNUMBER(SEARCH('VARIABLE LUT'!$B$12,Q3:Q15)))

If that works then I think another option would be
=FILTER(R3:R15,P3:P15&"|"&Q3:Q15='VARIABLE LUT'!$B$16&"|"&'VARIABLE LUT'!$B$12)