Tag Archives: SUMPRODUCT

Looking Up Multiple Criteria with INDEX and SUMPRODUCT

JP Pinto won the fan-favorite Great White Shark award for his previous post about Cascading Validation Lists. The folks at the Office Online blog asked JP to do a new guest post for the Excel blog and JP’s post on using INDEX and SUMPRODUCT to do a two-criteria lookup is now available here. This looks like a cool technique. JP starts out by using SUMPRODUCT to return a numeric value from a column. But if you need to return a text value, the INDEX with SUMPRODUCT and ROW solves the problem.