As the war wages on between #TEAMVLOOKUP and #TEAMINDEXMATCH, a new challenger has arisen. #SUMPRODUCT, a function often associated with math and trig, has now taken on a new purpose – Boolean logic. But can it compete? Or, will it continue to lurk in the shadows, only to be utilized by Power Users… Download Workbook […]Read more "I Always Feel Like SUMPRODUCT()’s Watching Me"
Not since the great territory battles of 7-Eleven Vs. Quiktrip, has there been such an unparalleled rivalry: “VLOOKUP or INDEX/MATCH?“A seemingly innocent question, when asked among Excel users, gives you a general perception of one another. There is one function’s inability to turn left and the others reliance on multiple functions for use. One’s perceived simplicity vs. the others perceived complexity. Are […]Read more "Defining The Great Divide"