I have noticed that I type a lot of iferror(vlookup(X,....) function in my daily work. Can i create a custom function that auto types those two together or does the same thing as those two. For example if I were to name the new function QuickV lets say then when I type QuickV and hit tab then it auto fills in the function iferror(vlookup( at which point I start to type in the arguments of the Vlookup and Iferror functions as needed? Not the greatest at VBA. Sample code would be great if this type of functionality is possible in excel 2013. Thanks in advance.
Bookmarks