Tag Archives: 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 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.


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 Read the rest of the post on the MS Office Blog, click here.


JP Pinto: “Cascading Validation Lists w/ VLookup”

JP Pinto checks in from Setúbal, Portugal and sends in a functional and very handy use of VLookup. As JP Pinto posts:

“Here’s the scenario: on our worksheet, we want to choose a Country and the corresponding City. We want to limit the countries available to the user as well as the cities that they can choose. For start, we want to choose the country and on the second cell we can only put cities that correspond to that country. It makes sense, right?”… To Read More Click Here to go to JP Pinto’s Lesson

JP Pinto may be found at Excel-User.com as well as the fan page Excel User on Facebook and on Twitter @excel_user


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

JP Pinto offers us another, more ‘back to basics’ use for VLookup:

“If we have a table of data, like the one shown bellow, and based on a value of that table want to return the value from another column we can use the VLOOKUP() function… To Read More Click Here to go to JP Pinto’s Lesson

JP Pinto may be found at Excel-User.com as well as the fan page Excel User on Facebook and on Twitter @excel_user