VL Instead of VLOOKUP - Custom Function Lessons Excel VBA - Easy!

In this lesson, we learn how to manipulate already existing functions to make our own cool functions. We took Vlookup and made our own vlookup using the letters VL. Then we got bored and made a function that works just like VLookup but used the word "Barbies". Fun! Check it out!

Fantastic Developer Tools:

[SrikumarRengaraj]

Hi Excel Guru, Is it possible to create a subtotal function ignoring errors in VBA. The Normal Worksheet function Subtotal doesn't ignore the errors.

[jetpaq]

thats so cool. I would name it "Magic" and mess with people >LOL  "Yea i  found this function in excel..called magic" works like vlookup..but its....magic.LMAO! this is priceless info bro..thank you so much.

[jamessmyth]

This is amusing. Inject a little chaos...

[alaaalimoh.]

Awesome, ,
But can you do the same concept in "datediff" function

[ModelbaanTBM]

Declaring a variable/parameter as variant doesn't require adding "As Variant". Although it might be neat. In this case not all the parameters should be Variant though. The second for example could be Range and the third Integer. Might be more memory efficient.

[IMJEFFJAY]

Quick tip": Control + Shift + A shows formula arguments.

[YourprogrammingnetworkCoUk]

I would avoid using this, custom functions are a lot less efficient than the built in excel formulas so all this is going to do is slow you calculations down. Considering how resource hungry vlookup is already this would cause havoc in larger spreadsheets, nice concept though for short handing formulas.