Results 1 to 11 of 11

Problems using Index/Match to pull multiple occurrences of "Match" criteria

Threaded View

  1. #1
    Registered User
    Join Date
    07-18-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    48

    Problems using Index/Match to pull multiple occurrences of "Match" criteria

    Good Morning,

    I am attempting to use the Index/Match to match each instance of "R&D" that is mentioned in Column B (B61:B100) (R&D Summary Tab), which have been pulled from the 'January Tab', and pull its subsequent "Description", "Date" and "$$" into the top 1/2 of the the same form --the "January Section" of the R&D Summary tab. The problem that I am running into, as you might imagine, is that the Index/Match formula is only matching the 1st instance of the "R&D" and not moving on the subsequent matches in the search array.

    I know that I most likely need to use some type of ROW function to help it determine when to move on, however, I am relatively new with excel, so I am struggling with the right combination. I know the solution is not difficult, but any help would be greatly appreciated.

    I have attached a sample spreadsheet for any possible assistance.

    Thank you in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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