Forum Discussion

certavi's avatar
certavi
Copper Contributor
Feb 22, 2020

INDEX MATCH function, avoid duplicate returns

Hi everyone!   I'm working on a sheet for work. I am on my last task and can't seem to figure this one out. I'm hoping someone can help:   I have a data sheet with all the data. In my current she...
Excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 22, 2020

    certavi 

    If you are on Excel with dynamic arrays that could be

    =UNIQUE(FILTER('Horse data'!B2:B100,
  (I$13='Horse data'!C2:C100) * ($K$13='Horse data'!D2:D100)
))
cweaver345414's avatar
cweaver345414
Copper Contributor
May 02, 2022

Brad Yundt im not able to attach my spreadsheet for some reason but hopefully these screenshots help. I am just trying to pull all quantities (equities) from Walleye sheet in to final sheet.

 

 

 

 

 

  • Brad Yundt's avatar
    Brad Yundt
    MVP
    May 02, 2022

    cweaver345414,

    "I did a Vlookup and that seemed to work!"

    That's why you should post a sample workbook in the thread, or a link to one in your OneDrive. You probably would have gotten the right answer the first time.

    Glad you got things sorted out.

     

    Brad

     

     

  • cweaver345414's avatar
    cweaver345414
    Copper Contributor
    May 02, 2022
    Please disregard! I did a Vlookup and that seemed to work!
  • cweaver345414's avatar
    cweaver345414
    Copper Contributor
    May 02, 2022

    Yeah but it looks like it isnt pulling anything from Walleye JPMCopy) sheet.Brad Yundt 

     

  • Brad Yundt's avatar
    Brad Yundt
    MVP
    May 02, 2022

    Have you tried the last formula I suggested? It should be working for the problem you show in the screenshots once you correct the names of the worksheets.
    =IFERROR(INDEX('Walleye JPMcopy)'!L$2:L$643,AGGREGATE(15,6,(ROW('Walleye JPMcopy)'!D$2:D$643)-ROW('Walleye JPMcopy)'!D$2)+1)/('Walleye JPMcopy)'!D$2:D$643="EQUITIES"),ROWS(D$2:D2))),"")

Resources