Results 1 to 4 of 4

Thread: INDEX/VLOOKUP Forumla for Unique List

  1. #1
    New Member
    Join Date
    Jan 2018
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default INDEX/VLOOKUP Forumla for Unique List

    Hello

    So I have manged to find a formula to help produce a list of unique names based on rules, but i can only get it to return the first name from the whole list.

    {=IFERROR(INDEX(Master!$B$2:$B$500,MATCH(0,COUNTIF(H$2,IF(Master!A$2:A$500=H$2,Master!B$2:B$500,H$2)),0)),"")}

    "Master B" is the range i want the names from
    H2 is the name/value i want it to check in Master A

    I then did th ctrl+shift+return trick, dragged it dwn but only the first name appears when i know there are more, yet al th sites i have looked at shows i will return the next name that matches H2

    Should i be using Vlookup in this to help it?

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,177
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: INDEX/VLOOKUP Forumla for Unique List

    How about
    =IFERROR(INDEX(Master!$B$2:$B$500,AGGREGATE(15,6,(ROW(Master!$B$2:$B$500)-ROW(Master!$B$2)+1)/(Master!A$2:A$500=H$2),ROWS($H$3:$H3))),"")
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    New Member
    Join Date
    Jan 2018
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: INDEX/VLOOKUP Forumla for Unique List

    Perfect! Thank you!!!

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,177
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: INDEX/VLOOKUP Forumla for Unique List

    You're welcome & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

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
  •