I like your formula over mine. I figured this was easier than I made it out
to be!

Biff

"Domenic" wrote in message
...
Hi Vane!

Sorry, my mistake! Try the following instead...

=INDEX(B$2:B$100,SMALL(IF(A$2:A$100=E$2,IF(MATCH(A $2:A$100&B$2:B$100,A$2:
A$100&B$2:B$100,0)=ROW(B$2:B$100)-ROW(B$2)+1,ROW(B$2:B$100)-ROW(B$2)+1)),
ROWS(F$2:F2)))

If the corresponding value in Column B can contain an empty cell, and
you don't want a zero returned, try...

=INDEX(B$2:B$100,SMALL(IF(A$2:A$100=E$2,IF(B$2:B$1 00<"",IF(MATCH(A$2:A$1
00&B$2:B$100,A$2:A$100&B$2:B$100,0)=ROW(B$2:B$100 )-ROW(B$2)+1,ROW(B$2:B$1
00)-ROW(B$2)+1))),ROWS(F$2:F2)))

Hope this helps!

In article ,
vane0326 wrote:

Hi Domenic nice to see you. I tested your formula and its not picking up
all the results. I attach the file below. Look at the texts that are
red. The formula is not picking up those results.


+-------------------------------------------------------------------+
|Filename: Lookup Ignore Duplicates 1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4827 |
+-------------------------------------------------------------------+