yogi_Check Availability Of items In List In Column K Against Entries in SubLists In Columns C E And G

                                          Google Spreadsheet   Post  #1284
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 14, 2013
user Tor Cunningham (http://productforums.google.com/forum/?zx=ewngtsw04aef#!category-topic/docs/spreadsheets/uNaxQSgShKk)
Filter rows where all items in row are contained in a list of items.
Hi everyone,

Todays problem ;)

I have a list of orders (have created sample sheet linked below) I also have a list of products that have enough stock to fill all current orders.

I have already tried a few IF statements in combination with ARRAYFORMULA, FILTER and FIND functions without much success.

I would like to put a formula into Sheet1!A2 that checks C2,E2,G2 against the list K2:K4. IF all products in C2,E2,G2 are contained in the list K2:K4 then the cell will display "YES", else "NO"

Then drag the formula down the column.

Any help is greatly appreciated.

Sample https://docs.google.com/spreadsheet/ccc?key=0AkPYLXk_Spk7dDA2ZHBxTF9aMjMwR2JxV3ZYTkNna2c&usp=sharing

Regards

----------------------------------------------------------------------------------------------------------------------------------------------------