ADVANCEDEXCELVBA.COM - All Posts

RSS

Two-Dimensional Lookups And Lookups With Mutliple Inputs

Friday, July 31, 2009 - 2:53 PM

If you have ever wanted to lookup a value from a table using input values for both the row and column, you may have found or created a formula that uses both the Index and Match worksheet functions. There is a another way to do it though, which is better in most cases.

See this link: http://support.microsoft.com/kb/275170. Not only does using data labels allow you to create two-dimensional lookups, you can even use multiple inputs for each of those dimensions!

Add comment

Creating Directories

Friday, July 31, 2009 - 1:53 PM

This function creates the directory supplied as an argument, creating folders and subfolders as needed. The last subfolder must be followed by a backslash.

Sample usage: fCreateDirectory("H:\Folder1\Subfolder1\")

Option Explicit
Option Base 1 'this is not necessary for this function

Public Function fCreateDirectory(sDirectory$) As Boolean
'uses FileFolderExists function

fCreateDirectory = True: On Error Goto Failed

If Not