How to get TRUE or FALSE based on 2 conditions?

Hello everyone, first of all sorry for making new thread while probably there are already similiar thread. I'm in middle confusion and deadline, so I really need your help.

In the attachment is sample cases of my problem. In the Sheet1 I have table with Store 1-7 and Product A-D. I need to fill the cell B4 to D10 with a word stating that shop have the product. While the data that contains the list in Sheet2.

For example, Store 1 got Product A, B, and D. So in the cells B4, C4, and E4 there will be 'TRUE' for stating.

I try using VLOOKUP, but I can't get it to working under 2 conditions.

Here's the attachment:
task.xls


Pardon my bad English. Thank you for your time to read this and kindly help.

If you are using Excel 2007:
=COUNTIFS(Sheet2!$B$3:$B$11,"A",Sheet2!$C$3:$C$11,1)>0
will return TRUE if there is productA for Store1. If you can change your table headers to only use A and 1 then you can use the same formula in all cells in the table:
=COUNTIFS(Sheet2!$B$3:$B$11,B$3,Sheet2!$C$3:$C$11,$A4)>0

If you must use Excel 2003 or an earlier version then you may use:
=SUMPRODUCT((Sheet2!$B$3:$B$11=B$3)*(Sheet2!$C$3:$C$11=$A4))>0

Everyone, thank you so much for your help!

Finally, my problem is solved. Once again, thank you very much.