vlookup with vba

[soumyajit]

how to vlookup sheet1 data in sheet2 with vba

 

[Colin Legg]

Very little information to go with... here is a general example:

[pre]

Sub example()

Dim varResult As Variant
Dim varLookUp_Value As Variant
Dim rngTable_Array As Range
Dim lngCol_Index_Num As Long
Dim blnRange_LookUp As Boolean

varLookUp_Value = Worksheets("Sheet1").Range("A1").Value
Set rngTable_Array = Worksheets("Sheet2").Range("A:B")
lngCol_Index_Num = 2
blnRange_LookUp = True

'this is equivalent of =VLOOKUP(Sheet1!A1,Sheet2!A:B,2,True)
varResult = Application.VLookup(varLookUp_Value, rngTable_Array, lngCol_Index_Num, blnRange_LookUp)

End Sub

[/pre]
I have broken this down as much as possible so you can see how it all works.

 

[Debraj]

Hi Soumyajit..


Please please please..


Either stop asking Question..

or start giving response on answer...


Please have a look your record..


http://chandoo.org/forums/profile/soumyajit

No of POST 18.. & No of TOPIC started 17..

Trying to figure it out.. in which post you have replied once..


We tried hard to solve your each and every question.. but we never received any response for any answer..


Its really a bad manner..


Regards,

Deb