filmov
tv
Vlookup Function Using VBA with Example

Показать описание
In this video, I have write a code to use Vlooup function using Macro with two example which will make it easy for yo understand it properly.
As informed before also on other videos, you can contact me for any Excel help or suggestions for new video through below mentioned contact details anytime.
---------------------------------------------------------------------
Code 1:
Sub vlookup()
Dim Name As String
Dim State As Variant
Name = "Ragini"
MyRange = Range("A1:C6")
MsgBox (State)
End Sub
Code 2 :
Sub Vlookup2()
Set Myrange = Range("A11:B16")
Set Name = Range("E12:E14")
Set Age = Range("F12:F14")
End Sub
-----------------------------------------------------------------
I upload Excel related tips & shortcuts which can save your time while working on the Excel sheet. I also upload tutorials in English & Hindi to understand the formula with some basic examples.
Contact Me :-
#EXCELONLINEADVISOR #microsoftexcel #exceltutorial
As informed before also on other videos, you can contact me for any Excel help or suggestions for new video through below mentioned contact details anytime.
---------------------------------------------------------------------
Code 1:
Sub vlookup()
Dim Name As String
Dim State As Variant
Name = "Ragini"
MyRange = Range("A1:C6")
MsgBox (State)
End Sub
Code 2 :
Sub Vlookup2()
Set Myrange = Range("A11:B16")
Set Name = Range("E12:E14")
Set Age = Range("F12:F14")
End Sub
-----------------------------------------------------------------
I upload Excel related tips & shortcuts which can save your time while working on the Excel sheet. I also upload tutorials in English & Hindi to understand the formula with some basic examples.
Contact Me :-
#EXCELONLINEADVISOR #microsoftexcel #exceltutorial