You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
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.
JP Pinto's post Cascading Validation Lists shows you how to use the CHOOSE and VLOOKUP functions to create a series of dropdown lists that "cascade" so that the choices in a second list depend on what you choose from a first list. You can use these lists to constrain the choices that users see in list boxes.
JP Pinto blogs at Excel-User.com, where he writes Excel articles for common users to help improve their skills.
Instead of using a CHOOSE and VLOOKUP function, INDIRECT function will be of more ease and will yield the same result.
very useful where one is using long list as drop down lists for data validation