Today’s author is Daniel Wiesenfeld, an Excel and Access Power User who is sharing his Extreme Lookup Collection with us so we can use the Excel User Defined Functions (UDFs) he created to enhance the lookup functionality. His web site daanalytics.com is currently under construction and should be available soon. In the Visual Basic Editor, insert a Module and paste the following code: ' XVLOOKUP (& XHLOOKUP) ' Works just like a vlookup (and hlookup) except that the user refers to a lookup
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2009/12/10/daniel-s-extreme-lookup-collection.aspx
Posted
Dec 10 2009, 06:08 PM
by
Microsoft Excel