http://blogs.office.com/b/microsoft-excel/archive/2012/04/04/vlookup-week-wrap-up-choose-the-winner-of-the-best-post.aspxVLOOKUP Week has ended. The brainchild of Excel MVP Bill Jelen, the idea inspired all things VLOOKUP, including VLOOKUP odes, haikus, vampires, and a way to track shark attacks. Setting all fun aside--Excel experts created a crazy number of useful anden-USTelligent Community 1.5.134.15456 (Build: 5.5.134.15456)http://blogs.office.com/b/microsoft-excel/archive/2012/04/04/vlookup-week-wrap-up-choose-the-winner-of-the-best-post.aspx#31031Mon, 09 Apr 2012 07:42:48 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31031SayantaniDas<p>The article which is gaining the most votes.. &quot;Using VLOOKUP inside Data Validation &quot; - Can be done with Indirect function as well... So there is a workaround for this... Whereas Idea#3 &quot;INDIRECT() to point to a variable sheet &quot; is the most useful according to my understanding :) Anyway each and every article here was very useful... learned a lot of tricks from this... I am an avid lover of VLOOKUP and would like to use this function anywhere and everywhere possible :)</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=31031" width="1" height="1">