# INDEX/VLOOKUP Forumla for Unique List

#### MJLG85

##### New Member
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?

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

#### Fluff

##### MrExcel MVP, Moderator
=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))),"")

#### MJLG85

##### New Member
Perfect! Thank you!!!

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback

1,089,395
Messages
5,408,003
Members
403,176
Latest member
mehtavish1