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

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

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.

"Max" wrote:

Try this sample file which contains the implemented construct:
http://cjoint.com/?kBqvXyjRnp
(Things should be clearer, I hope)

The formula you gave me for column E
puts the row #, not the value in the cell.

Yes, nothing wrong there <g. Col E is a helper criteria col. The row
numbers returned are arbitrary values which will be read by the formulas in
sheet: B

Also, the formula you gave me to put in A1 is looking at row E in
worksheet
B, not worksheet A where the data is. How do I change that to lookin
column
E, worksheet A?

Nothing wrong here, too. The desired unique values are returned correctly
from col A in Sheet: A by the INDEX(A!A:A ... part of the formula which
points to col A in sheet: A.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"JANA" wrote in message
...
Thanks Max, still a problem though. The formula you gave me for column E
puts the row #, not the value in the cell.

Also, the formula you gave me to put in A1 is looking at row E in
worksheet
B, not worksheet A where the data is. How do I change that to lookin
column
E, worksheet A?