Macro for vlookup

[Alka Bajaj]

Hello Expert,

Currently I am using vlookup between two sheets to get the desired output.

Steps Executed
1.Insert a column in sheet1 to put vlookup value
2.Perform vlookup function by refering sheet2

I need to automate the above steps using Macro. Please advise.
Appreciate your guidance.

Many Thanks.

Regards,
Alka

 

[John Davis]

Hi John,

Tried below mentioned code. But it is not doing vlookup. It is just creating a new column with a header,

There was an errant space in the range. Now try it.

Sub lookup()

Columns("H:H").Insert Shift:=xlToRight
With Range("H2:H1000")
.Formula = "=VLOOKUP(G2,ZDT_HR_CON_PERN!$I$2:$AG$50000,25,FALSE)"
.Value = .Value
End With
Range("H1") = "YOUR HEADER TITLE"

End Sub