JP Pinto

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(…)

And the winner of the VLOOKUP Great White Shark Award is…


JP Pinto!  Congratulations! His post was one of seven chosen by Bill Jelen as the most innovative ones published during VLOOKUP Week.  He won a copy Bill Jelens book Microsoft Excel 2010 In Depth. You can find links to all seven posts and see the voting results in our wrap-up post of VLOOKUP Week. …To(…)

JP Pinto: “Cascading Validation Lists w/ VLookup”


We want to choose a Country and the corresponding City…

JP Pinto: “Get A Value Based on Another Value”


Beginning in VLookup in MS Excel

Learn Excel from MrExcel