OK. It works fine while in the test.xls. However, when I enter the formula
in the overall.xls it still comes up with repeats.

Could there be something in the cells that is causing this to happen? Wrong
number format or something?

"Max" wrote:

Think this should yield correctly what is required

In Sheet1
---------
Put in A1:

=IF(ISERROR(SMALL(Overall!$K:$K,ROWS($A$1:A1))),"" ,
INDEX(Overall!F:F,
MATCH(SMALL(Overall!$K:$K,ROWS($A$1:A1)),Overall!$ K:$K,0)))

A slight correction made to the row incrementer part:
... ROWS($A$3:A3) ...

In the starting cell, irrespective of which row this might be in,
the row incrementer part must always be:
... ROWS($A$1:A1) ..

Put instead in B1:

=IF(ISERROR(SMALL(Overall!$K:$K,ROWS($A$1:A1))),"" ,
INDEX(Overall!A:A,
MATCH(SMALL(Overall!$K:$K,ROWS($A$1:A1)),Overall!$ K:$K,0)))

(The previous formula in B1 needs to be revised. The revised formula is
essentially the same formula as that placed in A1 above, except that it
points to col A in Overall, to retrieve the PO Number.)

Select A1:B1, fill down
Cols A & B should now return the correct results
---
Just a side note on your labelling in Overall's K2. As col K is actually an
arbitrary criteria cum tie-breaker col, I'd simply label K2 as, say,
"TieBreak" instead, to avoid any future confusion with the actual col G
"Date issued".
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--