http://blogs.office.com/b/microsoft-excel/archive/2012/04/11/great-white-shark-award.aspxJP 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 votingen-USTelligent Community 1.5.134.15456 (Build: 5.5.134.15456)http://blogs.office.com/b/microsoft-excel/archive/2012/04/11/great-white-shark-award.aspx#31350Mon, 28 May 2012 04:48:37 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31350Jaiveer<p>very useful where one is using long list &nbsp;as drop down lists for data validation</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=31350" width="1" height="1">http://blogs.office.com/b/microsoft-excel/archive/2012/04/11/great-white-shark-award.aspx#31047Thu, 12 Apr 2012 15:08:36 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31047Ryan Das<p>Instead of using a CHOOSE and VLOOKUP function, INDIRECT function will be of more ease and will yield the same result.</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=31047" width="1" height="1">