Try...

F2, copied down:

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

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
vane0326
wrote:

Hi Biff maybe I'm looking over something so I attach a sample file
below. Please let me know what I'm doing wrong. What do you think*?*


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