Hi
i have a code below to fill out my lookups but there is something wrong on it. please help me to correct this code. I need to lookup P2 to 2 different sheets. P2 needs to find on Master sheet and Support sheet.
Sub lookups()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationAutomatic
Sheets("Cleaned Raw").Select
With Range("Q2")
.Formula = "=VLookup(P2,'Master'!$E:$J,5,False),VLookup(P2,'Support'!$E:$J,5,False)"
With .Resize(Range("P" & Rows.Count).End(xlUp).Row - 1)
.FillDown
.Copy
.PasteSpecial xlPasteValues
End With
End With
End Sub
Bookmarks