Application.WorksheetFunction.VLookup Not Accepting Date as Lookup Value

  • This is so frustrating. I can get the VBA Application.WorksheetFunction.VLookup to perform when the lookup value a string, but trying to use a date it continually gives me an error of: Runtime Error "1004" Unable to get the VLookup Property of the Worksheet Function Class


    The code I am using is below:



    I have also attached a test file I am using.


    Regards,

  • Re: Application.WorksheetFunction.VLookup Not Accepting Date as Lookup Value


    Hello,


    You can test following ...



    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!