Forum Discussion
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...
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) ))
Please disregard! I did a Vlookup and that seemed to work!
"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
