Vlookup With VBA in Excel

Vlookup With VBA in Excel can be used very easily. Hello and welcome to Myelesson and in this video I am going to teach you how you can vlookup formula in excel with VBA code. Yes , you can apply vlookup with vba code like I have shown in this example. Wherein you have to enter the name of the person here then his salary is shown here by pressing the Vlookup button. The data is coming from this table. When we press the Next button then the data is cleared and you can enter the new name. Let me show you how you can do it. So over here I have this column of name and this column of salary . every persons salary is mentioned against his name. Now we have to see that column numbers of this data that is column C and D. Now we will write the code for the vlookup formula in vba. I will click on Developer tab and insert 1 text box where we will write the name of the person and insert 1 more text box to show his salary. Then we will insert a button to run our vlookup formula. Now we will start writing our code , lets click on this button and lets declare a variable empname as string and another variable empsal as long and lets define our lookup range as myrange so we will type myrange = range("c:d"). and now we will type sal = application.worksheetfunction.vlookup(textbox1.value),myrange,2,false) and ten we will pass the value of this in textbox 2 by typing textbox2.value=sal
** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel
https://www.youtube.com/watch?v=KyMj8HEBNAk

Learn Basic Excel Skills For Beginners || Part 1
https://www.youtube.com/watch?v=3kNEv3s8TuA

10 Most Used Excel Formula
https://www.youtube.com/watch?v=2t3FDi98GBk

**Most Imporant Excel Formuls Tutorials**

Learn Vlookup Formula For Beginners in Excel
https://www.youtube.com/watch?v=vomClevScJQ

5 Excel Questions Asked in Job Interviews
https://www.youtube.com/watch?v=7Iwx4AMdij8

Create Speedometer Chart In Excel
https://www.youtube.com/watch?v=f6c93-fQlCs

Learn the Basic of Excel for Beginners || Part 2
https://www.youtube.com/watch?v=qeMSV9T1PoI

Create Pareto Chart In Excel
https://www.youtube.com/watch?v=2UdajrDMjRE

How to Create Dashboard in Excel
https://www.youtube.com/watch?v=RM8T1eYBjQY

Excel Interview Questions & Answers
https://www.youtube.com/watch?v=Zjv1If63nGU
To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788
Connect with us on Facebook - https://www.facebook.com/excelmadeasy/
Connect with us on Twitter - https://twitter.com/Excelmadeasy

Видео Vlookup With VBA in Excel канала My E-Lesson