I found the bad cell. It was formatted as a number vice date and was putting
out bad info. It is all good now.

Thanks.

"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
--