+ Reply to Thread
Results 1 to 2 of 2

VBA Vlookup (Error Unable to get the VLookup property of the WorksheetFunction Class)

  1. 12-07-2020, 11:25 PM #1
    HeHeHaHa
    HeHeHaHa is offline
    Registered User
    Join Date
    12-15-2014
    Location
    singapore
    MS-Off Ver
    2013
    Posts
    45

    VBA Vlookup (Error Unable to get the VLookup property of the WorksheetFunction Class)

    Hi I am comparing two columns of info with below code

    I wanted to return Match if found

    Else Not Found

    However having error code at the vlookup line

    Please advise.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 12-08-2020, 05:16 AM #2
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,110

    Re: VBA Vlookup (Error Unable to get the VLookup property of the WorksheetFunction Class)

    The WorksheetFunction version of VLookup returns a runtime error if the match is not found. Use:

    Please Login or Register  to view this content.
    Everyone who confuses correlation and causation ends up dead.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Vlookup Error - unable to get the vlookup property of the worksheetfunction class
    By forrestgump1980 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-14-2019, 02:59 PM
  2. [SOLVED] run-time error '1004' unable to get the vlookup property of the worksheetfunction class
    By Sintek in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-23-2016, 02:26 PM
  3. “Unable to get the VLookup property of the WorksheetFunction Class” error
    By lougs7 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-13-2015, 11:22 AM
  4. Unable to get the Vlookup Property of the WorkSheetFunction Class
    By jayeshsondhi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2015, 03:57 AM
  5. [SOLVED] Unable to Get the Vlookup property of the WorksheetFunction class
    By DrowingInVBA in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-19-2013, 02:02 PM
  6. Run-time Error 1004: Unable to get the VLookup property of the WorksheetFunction class
    By sridhar_neel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-10-2012, 04:21 AM
  7. Unable to get the Vlookup property of the WorksheetFunction class
    By DoctorG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2006, 02:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1