Here you are going to learn the way how you can modify the Vlookup functionality, when there is a requirement to do in your Excel report using User defined function technique.
In order to do this, you need to add the module in the excel by pressing the Alt+F11 key or selecting the view menu then select the view macro option.
Once you get the module, you need to specify the function name and functionality to modify the Vlookup according to your requirement. This is a very simple process to excel beginners also. Any excel function can be modified using this method.