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.
April 27, 2012
Looking Up Multiple Criteria with INDEX and SUMPRODUCT
By Bill Jelen
About Bill Jelen
Author of 31 books about Microsoft Excel. View all posts by Bill Jelen
This entry was posted on Friday, April 27th, 2012 at 18:00 and tagged with INDEX, JP Pinto, SUMPRODUCT and posted in Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed.
Leave a Reply Cancel reply
Excel Lookup Function
Function by NameAdvanced VLookup Array Atlas Programming Management Inc Basic Bill Jelen Case Colin Legg Crystal Long Dan Bricklin Data Validation Excel Excel 2010 ExcelisFun HLookup How To Set Up A VLookup in Excel INDEX Ivana Taylor Javier Guillén JP Pinto LOOKUP Lookup Function MATCH Microsoft Blog Microsoft Excel Microsoft MVP Microsoft Office Blog Mike Girvin MrExcel MS Access MS Excel MSExcel MSMVP Pearson Publishing PowerPivot QUE Publishing Software Tom Urtis VisiCalc Visual Basic VLookup VLOOKUP and PowerPivot VLookup Formula VLookup Formulae VLookup in Excel Vlookup Week