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

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

yogi_Query Data based On Header Names in Row 1 Of Summary Sheet

                                          Google Spreadsheet   Post  #1261
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 25, 2013
user Tor Cunningham (http://productforums.google.com/forum/?zx=ksirz5o3le8l#!category-topic/docs/spreadsheets/NRDcG9PYcCw)
Query data based on header names
I have a large array of data in one sheet which I want to summarize in a second sheet.

I need a formula to bring across data depending what header is in the first row.

So in the example sheet linked below I would like to insert a formula in Summary!A2 that will bring through data for all three columns that have the same header in the corresponding data sheet no matter what order they are in.

I have previously just used a formula in each column but now have many data sheets that have header names in different places and it makes merging the data difficult.

sample sheet link:

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

thanks in advance for any help

Tor

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