+ Reply to Thread
Results 1 to 20 of 20

Replace Index Match with VBA - Multiple Criteria - Thousands of rows and columns

Hybrid View

  1. #1
    Registered User
    Join Date
    09-29-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Office 2013
    Posts
    13

    Re: Replace Index Match with VBA - Multiple Criteria - Thousands of rows and columns

    Ok, GC, I played with it more and actually found the right window. The ar has no plus sign beside it. the other variables can be expanded, but not ar.
    Module1 has a plus
    Dic has a plus
    shNames has a plus
    ws has a plus

    Dict, ar, I,n,j,sName,rg and c do not have a plus.

    As I said all data should start on A1, this could be changed. Currently I only placed data in the JAN tab until we get it working.

    Edit:
    I added a line to Feb as it seems that was where it was getting the error. Now I am back to the Runtime 457 error, that was due to a duplicate date, I changed it and MAR was the culprit tab.
    I added a line to each month and now it works!

    Does this mean I will need to make a fictitious person to start each month or it will not work? Normally those tabs would stay empty until the start of the month.
    Last edited by jaybrd1; 04-29-2014 at 07:25 PM.

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,414

    Re: Replace Index Match with VBA - Multiple Criteria - Thousands of rows and columns

    Edit:
    I added a line to Feb as it seems that was where it was getting the error. Now I am back to the Runtime 457 error, that was due to a duplicate date, I changed it and MAR was the culprit tab.
    I added a line to each month and now it works!

    Does this mean I will need to make a fictitious person to start each month or it will not work? Normally those tabs would stay empty until the start of the month.
    I just saw your last post, so what I just said probably does not make sense.
    When the code stops, click debug then hover your mouse on the line highlighted in yellow.

    It should break at :

                    Dic(ar(i, 1)).Add ar(i, 7), ar(i, 10)
    if you place the cursor over ar(i, 1), ar(i, 7) and ar9(i, 10), what values do you see?
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

+ 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. VLookup or Index/match searching rows instead of columns or multiple criteria
    By Groovicles in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-16-2013, 05:00 PM
  2. [SOLVED] INDEX+MATCH with multiple criteria across both rows and columns
    By george_k in forum Excel General
    Replies: 3
    Last Post: 10-26-2012, 04:11 PM
  3. Index and Match with multiple columns/rows
    By fab121 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2012, 02:33 PM
  4. [SOLVED] Index and Match Multiple Header (Rows) Criteria
    By dluhut in forum Excel General
    Replies: 7
    Last Post: 04-12-2012, 06:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1