+ Reply to Thread
Results 1 to 2 of 2

Want all results resulting from index/match

Hybrid View

  1. #1
    Registered User
    Join Date
    03-26-2015
    Location
    Bakersfield, CA.
    MS-Off Ver
    2010
    Posts
    1

    Want all results resulting from index/match

    Okay, I finally broke down after reviewing all possible threads on this forum and a few other forums over the weekend. I have attached a small file for clarification. First, I would like to have all the results that meet the match criteria to be returned across columns instead of down rows. I have a formula that works except 1. it only pulls the first matching event and not subsequent events and 2. it only works if I copy the formula down the rows but not across columns. For instance, at D13/E13, I would expect to see the results as in F13/G13. At D14/E14 I would expect results as in F14/G14 and so on. I know there are duplicates in the B/C columns but I ma not too concerned with that. My main concern is the resulting return of information based on the match criteria. So although B/C 13 is the same as B/C 16 tha's not a problem. At first i thought the duplicates in B/C were causing the conflict bu even after I eliminated the duplicates in those columns, the formula did not work as expected. I have tried tweaking the formula I used in column D bu no joy. There are also 2 other formulas at the bottom on lines 29 and 30 that I have used with limited success. Again, copying the formula down gives me a result of the first instance only and not the subsequent finds. I am trying to stay away from a "helper" because my original data is massive. Any assistance would be greatly appreciated as I have beat my head against the wall on this for several days. Thanks in advance...Al
    Attached Files Attached Files

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2409
    Posts
    2,789

    Re: Want all results resulting from index/match

    I put some formulas in rows 13 and 14 you can copy them down and up and across.
    Attached Files Attached Files

+ 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. [SOLVED] Not getting expected results from index match match
    By number1mm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-25-2013, 03:56 PM
  2. Index/Match with multiple results
    By kwadjo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-26-2013, 04:05 PM
  3. [SOLVED] Using Index & Match always results in #N/A
    By ioswoody in forum Excel General
    Replies: 3
    Last Post: 07-05-2012, 01:52 AM
  4. Index Match only 4 results required
    By pepe.r.taylor in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-31-2011, 11:28 PM
  5. Index match and count results
    By dpatel in forum Excel General
    Replies: 2
    Last Post: 05-27-2011, 06:54 AM

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