Sunday, July 14, 2013

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   Jul 14, 2013
user Tor Cunningham (!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.