Friday, April 5, 2013

yogi_Pull Results From Another Sheet Using Multiple Criteria


                                          Google Spreadsheet   Post  #1096
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 5, 2013
user Stephen Seattle1 :(http://productforums.google.com/forum/?zx=zd9wmltvkm4a#!category-topic/docs/spreadsheets/FYCW2mNzTjM)

I currently use a couple of formulas to return results from one sheet to another based on a match of identified date fields.  In the spreadsheet link below, my formulas are located in cells A5 and B5 in the 'Press Orders' sheet.  The formulas matches the date in cell A4 (Press Orders sheet) to any matching dates in column K in the 'Sales Data' sheet and returns results located in specified columns of the 'Sales Data' sheet.  The formulas work great.  But I want to add one more element to the formula.  I want to look for matching dates in not only column K, but also column M.  So, if a matching date is located in either (or both) columns, then return the same specified results.  How do you add this second parameter to my formulas?
 
 
Thank for your assistance,
Stephen
-----------------------------------------------------------------------------------------------------------------
folloowing is a solution to the problem