How to make a formula return results with multiple criteria
by StephenSeattle - 4/5/13 2:33 PM
I currently use a couple of formulas in a Google Docs spreadsheet to return results from one sheet/tab 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/tab. The formulas matches the date in cell A4 (Press Orders sheet/tab) to any matching dates in column K in the 'Sales Data' sheet/tab 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 I add this second parameter to my formulas?
SPREADSHEET LINK: https://docs.google.com/spreadsheet/ccc?key=0AqB-QCD3CXigdDJLZkphMnZYLVJQbFZtdHpER1pSdkE&usp=drive_web#gid=2
Thank for your assistance,