Sunday, September 23, 2012

And the winners of the great white shark VLOOKUP is...

VLOOKUP Week's Great White Shark Award WinnerJP Pinto!  Congratulations!

His contribution was one of the seven selected by Bill Jelen as the most innovative, while VLOOKUP weekreleased.  He won a copy of that book Bill Jelens Microsoft Excel 2010 in depth. You can find links to all seven posts and the results of voting in our summary of the VLOOKUP week postsee.

JP Pinto post cascading validation lists will show you how you select and use VLOOKUP function, create a set of drop-down lists, the "", Cascade so that the choices in a second list depends on depending what you, a first list choose. You can restrict the choices these lists, displayed to the user in list boxes.

Cascading Dropdown List

JP Pinto blogs on Excel-User.com, where he writes Excel articles for common users to help improve their skills.


View the original article here

No comments:

Post a Comment