+ Reply to Thread
Results 1 to 3 of 3

unable to get the vlookup property of the worksheet function class

  1. 10-08-2014, 07:34 AM #1
    zak.horrocks
    zak.horrocks is offline
    Forum Contributor
    Join Date
    09-09-2014
    Location
    England
    MS-Off Ver
    2013
    Posts
    102

    unable to get the vlookup property of the worksheet function class

    Hello I am getting the error message above. My code is:

    Please Login or Register  to view this content.
    any ideas? Everything is looking up at the right bits as far as I can see.

    Thanks

    Zak
    Reply With QuoteRegister To Reply
  2. 10-08-2014, 07:45 AM #2
    romperstomper
    romperstomper is offline
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: unable to get the vlookup property of the worksheet function class

    It means there is no match for the value in combobox3 in the lookup range.
    Remember what the dormouse said
    Feed your head
    Reply With QuoteRegister To Reply
  3. 10-08-2014, 08:01 AM #3
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: unable to get the vlookup property of the worksheet function class

    What is in combobox3 and in column D in sheet2 ?
    May be you have something you are not noticing (for instance a space) there?
    TRIM could help then.
    Best Regards,

    Kaper
    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. error 1004 unable to get the vlookup property of the worksheet function class
    By steve99g in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2013, 04:35 PM
  2. [SOLVED] unable to get the sumif property of the worksheet function class -> HELP!!!
    By stadjer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2012, 07:32 AM
  3. Run time error 1004 unable to get the vlookup property of the worksheet function class
    By surajitbose in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2012, 06:12 PM
  4. Unable to Match property of Worksheet class function
    By bambino_32 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2010, 05:38 AM
  5. Unable to get countif property of the worksheet function class
    By mikeyfear in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2008, 06:53 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