Hi,
I am trying to understand why this vlookup formula is not working -
So for example if Lookupvalue is the year 2001, then Growth should be 10%
when i run the sub, the value of Growth comes out as 0, and i get a type mismatch error.
Dim LookupValue As Integer
Dim Range1 As Range
Dim Growth As Double
LookupValue = Sheets("Temp").Cells(KeyCell, 3).Value
Set Range1 = Sheets("Temp").Range("J8:K12")
Growth = Application.VLookup(LookupValue, Range1, 2, False)
Year Usage
2001 10%
2002 20%
2003 5%
2004 1%
Bookmarks