VLOOKUP USING VBA

[Sarfraz Khan]

dear SIr,

I wanted to use Vlookup using VBA, Can you please help me to do.

 

[Marc L]

Hi,

you can use either Evaluate method or Application.Vlookup …
​

 

[achu]

Hello,


I am excited to see this forum as I have gotten a lot of great tips from PHD and look forward to learning more. Keep up the great work!

 

[achu]

Hi i want to vlookup in excel vba

sample file attached here

 

[Deepak]

Hi i want to vlookup in excel vba

sample file attached here

Hi @achu

One must should to start a new thread for very own query as what u did might be called hijacking.

see this ...

Sub vlook()
    Range("F4:F127").Formula = "=VLOOKUP(B4,Sheet2!$A$4:$B$127,2,0)"
    Range("F4:F127").Value = Range("F4:F127").Value
End Sub

 

[achu]

Hi Deepak,

can you help me to using code with Macro below given details


Countif
Sum If
Sum Product
IF and

Below my required data and attached file here.


Total Booking Total Aeea
Vakas
Indigo
Fern
Ivy
Periwinkle
Residency-3
Orion-3
Galaxy-2
Nakshatra
Bella Vista
From Date Total Booking Total Aeea
To Date
Vakas
Indigo
Fern
Ivy
Periwinkle
Residency-3
Orion-3
Galaxy-2
Nakshatra
Bella Vista

 

[Deepak]

@achu

Would u pls start a new thread for the same.