Hey I was wondering if anyone who had some experience with arrays could help me out on this one. I have a formula that returns a list of unique names based on a part # for a number of columns. I used the formula below to reference a a page of raw data:

INDEX('DATA 3-1-10 TO 3-22-12'!$B$2:$B$14092,SMALL(IF('UN SCHEDULE'!B13='DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092,ROW('DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092)-MIN(ROW('DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092))+1,""),ROW($A1)))

Outside of that I addeda vlookup in front of the formula to reference the cust name the above formula returns, and vlookup an email from a third sheet with customer information.

For some reason no matter how i change around the $ signs. When i pull the equation down or to the right, it either copies the entry from the first row or just returns one email even though there are many more. Here is the whole equation:

{=IFERROR(IF(VLOOKUP(INDEX('DATA 3-1-10 TO 3-22-12'!$B$2:$B$14092,SMALL(IF('UN SCHEDULE'!B13='DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092,ROW('DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092)-MIN(ROW('DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092))+1,""),ROW($A1))),'CUSTOMER EMAIL LIST'!$B$2:$K$602,10,0)="NOT AVAILABLE",VLOOKUP(INDEX('DATA 3-1-10 TO 3-22-12'!$B$2:$B$14092,SMALL(IF('UN SCHEDULE'!B13='DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092,ROW('DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092)-MIN(ROW('DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092))+1,""),ROW($A1))),'CUSTOMER EMAIL LIST'!$B$2:$K$602,8,0),IF(VLOOKUP(INDEX('DATA 3-1-10 TO 3-22-12'!$B$2:$B$14092,SMALL(IF('UN SCHEDULE'!B13='DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092,ROW('DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092)-MIN(ROW('DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092))+1,""),ROW($A1))),'CUSTOMER EMAIL LIST'!$B$2:$K$602,10,0)="DEAD",VLOOKUP(INDEX('DATA 3-1-10 TO 3-22-12'!$B$2:$B$14092,SMALL(IF('UN SCHEDULE'!B13='DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092,ROW('DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092)-MIN(ROW('DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092))+1,""),ROW($A1))),'CUSTOMER EMAIL LIST'!$B$2:$K$602,1,0),VLOOKUP(INDEX('DATA 3-1-10 TO 3-22-12'!$B$2:$B$14092,SMALL(IF('UN SCHEDULE'!B13='DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092,ROW('DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092)-MIN(ROW('DATA 3-1-10 TO 3-22-12'!$D$2:$D$14092))+1,""),ROW($A1))),'CUSTOMER EMAIL LIST'!$B$2:$K$602,10,0))),"")}

Please let me know if anyone can help. im sure its something simple im just missing.

Thanks Ry