So, the formula is working, but not pulling the LC data. How do I fix
this?

I think you probably amended the original formula suggested for sheet: B

Re-check the formula you have placed in A1 in sheet: B,
and ensure that the INDEX part of it is reading: ... INDEX(A!A:A,
[ Do *not* change this part to: INDEX(A!E:E .. ]

Here's the original suggested formula again for your reference

In sheet: B
-------
Put in A1:
=IF(ISERROR(SMALL(A!E:E,ROWS($A$1:A1))),"",
INDEX(A!A:A,MATCH(SMALL(A!E:E,ROWS($A$1:A1)),A!E:E ,0)))
Copy down ...

Btw, did you try the sample file provided in my previous post ?
It contains the working implementation ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"JANA" wrote in message
...
Max,
Thanks for all your patience. I've almsot got it working. Got the
formulas
to both work correctly, they just are still entering row numbers instead
of
the actual data in the cell. In worksheet A, the formulas I set up in
Column
E is listed as follows based on my example:
WORKSHEET A
A E
1 S1 1
2 T3 2
3 T4 3
4 S1
5 T3
6 S2 6

Worksheet B now lists this:

WORKSHEET B
A
1 1
2 2
3 3
4 6


THANKS



You say this is fine, it's just a value. In Worksheet B, the formula is
working correctly, but still lists the exact values from Column E, the row
numbers and not the LC data.