Sorry, just detected, there's a slight correction to the earlier:
=IF(A1="","",INDEX(Sheet1!A:A,MATCH($A1,Sheet1!$F: $F,0)))
it should have read as:
=IF($A1="","",INDEX(Sheet1!A:A,MATCH($A1,Sheet1!$F :$F,0)))
(Missed the "$" for the front IF's $A1)
Anyway, guess my other suggestion -- the alternative interp on your post --
names listed may not be unique, may appear multiple times in col F seems to
be what you were after.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---