+ Reply to Thread
Results 1 to 4 of 4

INDEX MATCH Error

  1. #1
    Forum Contributor
    Join Date
    09-02-2013
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    256

    INDEX MATCH Error

    Hello Excellers,

    Can you help me understand and resolve what's wrong with the following code? Sometimes, it does work but then after one or two test, I get this 1004 error message 'Unable to get the Match property of the WorksheetFunction class'.

    It is a vba in a form to search the value of the textbox1 (which is a shorthand ISO CODE of the corresponding value in the combobox1), based on the value given in the combobox1.


    Please Login or Register  to view this content.
    My form has 2 combo boxes and 1 text box.
    The Combobox3 has a category value, the second, Combobox1, has a dependent value, based on the Combobox3 and the listbox1 just vlookup for the corresponding shorthand code for the value in Combobox1

    Example: ComboBox3: Bank / ComboBox1: NatWest / ListBox1: NW

    Thank you very much for any of your advices, suggestions or helps and your contribution is much appreciated.
    Last edited by rakotonirinas; 05-22-2018 at 06:58 AM. Reason: No replies

  2. #2
    Forum Contributor
    Join Date
    09-02-2013
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    256

    Re: INDEX MATCH Error

    The error message only appears when I change the value within the combobox3, which is the category list. Is there any connection here?
    Last edited by rakotonirinas; 05-10-2018 at 08:17 AM.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,432

    Re: INDEX MATCH Error

    The MATCH function is looking for an exact match (governed by the 0 term) - are you sure that there is an exact match?

    Pete

  4. #4
    Forum Contributor
    Join Date
    09-02-2013
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    256

    Re: INDEX MATCH Error

    @Pete_UK. Yes it is all on exact match because I am only pulling the corresponding shorthand code of the value in the Combobox3

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. unable to get match property error in userform derived index match
    By alexcrofut in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-05-2015, 09:21 PM
  2. [SOLVED] Index and Match Error
    By nironto in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-19-2015, 08:54 PM
  3. INDEX MATCH Error
    By rikapple in forum Excel General
    Replies: 16
    Last Post: 08-17-2014, 03:34 AM
  4. [SOLVED] Index/Match Error
    By pauldaddyadams in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-28-2013, 07:41 AM
  5. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  6. [SOLVED] INDEX MATCH error
    By Ozwilly in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-07-2012, 10:27 PM
  7. Index, Match, #REF Error
    By karstens in forum Excel General
    Replies: 9
    Last Post: 01-04-2011, 07:11 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1