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?
SPREADSHEET LINK: https://docs.google.com/
Thank for your assistance,
Stephen
-----------------------------------------------------------------------------------------------------------------
folloowing is a solution to the problem
Thank you, Yogi. I could have sworn I edited and tried this formula on my own earlier and it did not work. :/ But it works now! Thanks!
ReplyDeleteI have been trying to figure out another formula for my spreadsheet that is giving me trouble. I am trying to return results to column K in the 'Press Orders' sheet. The results would be pulled from column M in the 'Customer Database' sheet based on a match of the name in column A (Press Orders sheet) to the same name located in column C (Customer Database sheet). I started out using the same syntax to my formula, but don't know how to finish it. This is what I got thus far: =query('Customer Database'!M$2:Y;ʺselect M where A= ...
ReplyDeleteHow do I finish this formula?