VBA Vlookup not functioning. Please Help?

[orozvik]

Here is the code:

Please Login or Register  to view this content.

The idea is that the variable c will receive the lookup value of 9 which is in the second column of a two column table range named rMonths. The vlookup formula will take the variable VActual which will hold the string "September" in it and find it in the range named table rMonths and return the value "9" in the second column to the variable C.

Somewhere I am not including something in the vlookup code line above. Can anyone help?

[orozvik]

Can someone help? It appears that the variable c will not receive the answer of 9 from the range table called rmonths which looks like this:

January 1
February 2

September 9

and so on.

The variable VActual holds the lookup value of "September" and should return the value in the table in the second column of 9 to variable "c".

?

[TMS]

Can I suggest that you upload a small sample workbook so that we can play with it.

Regards, TMS