Hi,
I have below vlookup code however when i ran it doesnt return any value? Can anyone help me with the issue. I dont receive any error messages. Thanks
I have below vlookup code however when i ran it doesnt return any value? Can anyone help me with the issue. I dont receive any error messages. Thanks
Sub Lookup()
Dim vResults As Range
Set vResults = ActiveSheet.Range("b2:b32")
Dim LookupValue As Range
Set LookupValue = ActiveSheet.Range("A2:A32")
Dim LookupRange As Range
Set LookupRange = ActiveSheet.Range("O233")
LookupColNum = 2
ExactMatch = False
For Each LookupValue In ActiveSheet.UsedRange
vResults = Application.WorksheetFunction.VLookup(LookupValue, LookupRange, LookupColNum, ExactMatch)
End Sub