Index Match data to provide multiple results in columns - Page 7

Thanks Thanks:  0
Likes Likes:  0
Page 7 of 7 FirstFirst ... 567
Results 61 to 62 of 62

Thread: Index Match data to provide multiple results in columns

  1. #61
    New Member
    Join Date
    Dec 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Index Match data to provide multiple results in columns

     
    Where is the link to the formula - I don't see it.
    thanks

    Quote Originally Posted by lomond44 View Post
    Using the example I linked to in my post, the data and results should look like this:

    Part No Assembly Lookup Match 1 Match 2
    Duck Daffy Duck Daffy
    Mouse Mickey Mouse Mickey Minnie
    Mouse Minnie Bunny Bugs
    Bunny Bugs Pig Porky
    Pig Porky Dog Goofy Pluto
    Dog Goofy
    Dog Pluto

  2. #62
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,443
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Index Match data to provide multiple results in columns

      
    Quote Originally Posted by teeltea View Post
    Where is the link to the formula - I don't see it.
    thanks
    Post #4 shows the formula you can use...
    Assuming too much and qualifying too much are two faces of the same problem.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com