I keep getting this error when trying to run this vlookup script. I am following an example which shows to work on their end, but not mine. I am trying to get this vlookup to populate cell P4 as my Group, and afterwards loop it until the end of the list. Please help!
Sub lookups()
'Lookup Product Group
Set myrange = Worksheets(2).Range("F:Y") 'KH Cost File CSV lookup range
Set SUPC = Worksheets(3).Range("A4") 'SUPC
Set Group = Worksheets(3).Range("P4")
Group.Value = Application.WorksheetFunction.VLookup(SUPC, myrange, 20, False)
End Sub
I tried changing the Application.WorksheetFunction to Application.Vlookup, but still getting issues.
