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"